PostgreSQL: Documentation: 17: 25.1. SQL Dump

pg_dump   pg_dump PostgreSQL pg_dump is a database tool that helps you make automatic, consistent backups. For example, you can back up offline and online databases. The utility The most simple case is dumping and restoring on the same server: $ pg_dump -h localhost -Fc test > /home/postgres/dump.sql $ pg_restore -h localhost test < /

pg_dump The pg_dump is a PostgreSQL backup and restores utility that dumps a PostgreSQL database into a script or archive file, Mengekspor semua database. pg_dumpall adalah utilitas yang memungkinkan Anda mengekstrak semua database PostgreSQL dari sebuah cluster ke dalam satu file skrip.

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. You have probably looked at logical dumps as supported by pg_dump and restores by pg_restore or, more simply, psql.