Learn how to take a complete logical backup of a PostgreSQL database using pg_dump and restore it into a new database using pg_restore.
In this tutorial, we cover:
PostgreSQL logical backup
Full database backup
Backup of tables, views, functions, procedures, and data
Restore backup into a new database
Step-by-step PostgreSQL backup and restore
pg_dump tutorial
pg_restore tutorial