Export and import using pg_dump, pg_dumpall, and pg_restore

pg_dump   pg_dump You have probably looked at logical dumps as supported by pg_dump and restores by pg_restore or, more simply, psql. What you might not have realized are the many options for dumping and restoring when multiple computers are involved. This tutorial shows you how to use PostgreSQL backup tools including pg_dump and pg_dumpall to backup databases in PostgreSQL.

pg_dump The pg_dump mand extracts a PostgreSQL database into a script file or another archive file. This utility is for backing up databases. The The pg_dump is a PostgreSQL backup and restores utility that dumps a PostgreSQL database into a script or archive file,

pg_dump You have probably looked at logical dumps as supported by pg_dump and restores by pg_restore or, more simply, psql. This option is recommended when dumping a database from a server whose PostgreSQL major version is different from pg_dump's, or when the output is intended to