pg dump

wikipedia:pg_dump (trends)

• https://www.postgresql.org/docs/current/app-pgdump.html
• brew install libpq

• pg_dump --help

• --schema-only

• --include-foreign-data (2020 PostgreSQL 13)

file your-dump
your-dump: PostgreSQL custom database dump - v1.14-0

pg_dump --version
pg_dump (PostgreSQL) 14.7 (Ubuntu 14.7-1.pgdg22.04+1)

Related terms

• pg_class, pg_stat
• pg_restore
• gcloud sql backups create
• Restore DB
• mysqldump
• Point-in-time recovery (PITR)
• PgBackRest
• pg dump --schema-only
• gitlab-backup create

See also

• pg_dump, pg_dumpall, WAL, PITR, PgBackRest, brew install pgpdump
• pg, pg_ctl, pg_dump, pg_dumpall, pg_restore, pg_class, pgaudit, pg_database, pg_cron, createdb, pg_backup_stop
• Database backups: mariabackup, mysqldump, mongodump, mariabackup, pg_dump, pgBackRest]