pg_dump extract a PostgreSQL database into a script file or other archive file

• https://pgpedia.info/p/pg_dump.html

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

Description

A core utility for backing up a single PostgreSQL database

pg_dump is a core utility for backing up a single PostgreSQL database as an SQL script, TAR archive or custom archive file.

pg_dump has been part of PostgreSQL since it was first released.

• pg_dump –help
• man pg_dump
  • PG_DUMP PostgreSQL 15.1 Documentation
    • Selects the format of the output
    • Dump only the object definitions (schema), not data
    • Specifies verbose mode
    • Print the pg_dump version and exit
    • Prevent dumping of access privileges (grant/revoke commands)
    • Specifies a role name to be used to create the dump
    • EXAMPLES
• pg_dump examples
  • Sauvegarde du schéma (–clean –if-exists –schema-only)
  • Sauvegarde des données (–clean –if-exists –schema-only)
  • Autre exemple
  • cat /root/scripts/backup_db.bash
    • Prérequis