任意のバックアップを実行する  

pg_dumpユーティリティを使用して、クライアントのローカルディレクトリにバックアップファイルを作成します。

以下は、ユーザsystem、パスワード(########)を使用して、test_dbデータベースのバックアップファイルを/tmp/backup.sqlに作成する操作例です。

$ pg_dump -U system -h <IPアドレス> -d test_db -v -f /tmp/backup.dump -F c
Password for user system: ########
pg_dump: last built-in OID is XXXXX
pg_dump: reading extensions
pg_dump: identifying extension members
pg_dump: reading schemas
pg_dump: reading user-defined tables
pg_dump: reading user-defined functions
pg_dump: reading user-defined types
pg_dump: reading procedural languages
pg_dump: reading user-defined aggregate functions
pg_dump: reading user-defined operators
pg_dump: reading user-defined access methods
pg_dump: reading user-defined operator classes
pg_dump: reading user-defined operator families
pg_dump: reading user-defined text search parsers
pg_dump: reading user-defined text search templates
pg_dump: reading user-defined text search dictionaries
pg_dump: reading user-defined text search configurations
pg_dump: reading user-defined foreign-data wrappers
pg_dump: reading user-defined foreign servers
pg_dump: reading default privileges
pg_dump: reading user-defined collations
pg_dump: reading user-defined conversions
pg_dump: reading type casts
pg_dump: reading transforms