Postgres Pro Enterprise : Documentation: 14: pg_dump

pg_dump   pg_dump Mastering PostgreSQL Backups with pg_dump pg_dump is a powerful PostgreSQL tool for creating backups. This guide provides a concise overview, pg_dump. The pg_dump tool is a command-line utility that you can use to create a logical backup of a PostgreSQL database. The pg_dump extracts a PostgreSQL

pg_dump pg_dump is a standard PostgreSQL utility for backing up a database, and is also supported in HAWQ. It creates a single dump file. The `pg_dump` mand in PostgreSQL is a utility used for creating backups of databases. It extracts SQL statements needed to recreate the

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. The pg_dump command extracts a PostgreSQL database and then turns it into a script file or an archive file. This utility command is used for backing up