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. pg_dump is a standard PostgreSQL utility for backing up a database, and is also supported in HAWQ. It creates a single dump file.

pg_dump The pg_dump is a PostgreSQL backup and restores utility that dumps a PostgreSQL database into a script or archive file, pg_dump is a regular PostgreSQL client application (albeit a particularly clever one). This means that you can perform this backup procedure from any remote

pg_dump pg_dump's -Z--compress in PostgreSQL 16 will support more than just an integer. It can be used to specify the method and level of pression used. The default pg_dump is already there in postgres's bin directory. So you just need to append that bin path manually to the PATH environment