任意のバックアップを実行する
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 |
・ |
・ |
・ |