AMD64 8.2.0 Build farm impala (FC6, gcc 4.1.1); bustard (FC5, gcc 4.1.0); wasp (FC5, gcc 4.1.0); viper (FC3, gcc 3.4.4) Fedora Linux PowerPC 8.2.0 Build farm sponge (FC5, gcc 4.1.0) Fedora Linux x86 x86 8.2.0 Build farm agouti (FC5, gcc 4.1.1); thrush (FC1, gcc 3.3.2) FreeBSD AMD64 8.2.0 Build farm platypus (6, gcc 3.4.4); dove (6.1, gcc 3.4.4); ermine (6.1, gcc 3.4.4) FreeBSD x86 8.2.0 Build farm command dumps a database using the custom dump format: 375 Chapter 23. Backup and Restore pg_dump -Fc dbname > filename A custom-format dump is not a script for psql, but instead must be restored with

AMD64 8.2.0 Build farm impala (FC6, gcc 4.1.1); bustard (FC5, gcc 4.1.0); wasp (FC5, gcc 4.1.0); viper (FC3, gcc 3.4.4) Fedora Linux PowerPC 8.2.0 Build farm sponge (FC5, gcc 4.1.0) Fedora Linux x86 x86 8.2.0 Build farm agouti (FC5, gcc 4.1.1); thrush (FC1, gcc 3.3.2) FreeBSD AMD64 8.2.0 Build farm platypus (6, gcc 3.4.4); dove (6.1, gcc 3.4.4); ermine (6.1, gcc 3.4.4) FreeBSD x86 8.2.0 Build farm command dumps a database using the custom dump format: 375 Chapter 23. Backup and Restore pg_dump -Fc dbname > filename A custom-format dump is not a script for psql, but instead must be restored with

Fedora AMD64 8.0.0 John Gray (), 2004-12-12 FC3 Fedora x86 8.0.0 Build farm dog, snapshot 2004-12-06 02:06:01 FC1 FreeBSD Alpha 7.4 Peter Eisentraut (), 2003-10-25 restored selectively. The following command dumps a database using the custom dump format: pg_dump -Fc dbname > filename A custom-format dump is not a script for psql, but instead must be restored with parts of the database are to be restored. The most flexible output file format is the “custom” format (-Fc). It allows for selection and reordering of all archived items, and is compressed by default. The tar

Fedora AMD64 8.0.0 John Gray (), 2004-12-12 FC3 Fedora x86 8.0.0 Build farm dog, snapshot 2004-12-06 02:06:01 FC1 FreeBSD Alpha 7.4 Peter Eisentraut (), 2003-10-25 restored selectively. The following command dumps a database using the custom dump format: pg_dump -Fc dbname > filename A custom-format dump is not a script for psql, but instead must be restored with parts of the database are to be restored. The most flexible output file format is the “custom” format (-Fc). It allows for selection and reordering of all archived items, and is compressed by default. The tar

2004-12-06 3.1 (sarge), kernel 2.6 Fedora AMD64 8.1.0 Build farm viper (FC3, gcc 3.4.2) Fedora x86 8.1.0 Build farm thrush (FC1, gcc 3.3.2) FreeBSD Alpha 7.4 Peter Eisentraut (), 2003-10-25 restored selectively. The following command dumps a database using the custom dump format: pg_dump -Fc dbname > filename A custom-format dump is not a script for psql, but instead must be restored with parts of the database are to be restored. The most flexible output file format is the “custom” format (-Fc). It allows for selection and reordering of all archived items, and is compressed by default. The tar

2004-12-06 3.1 (sarge), kernel 2.6 Fedora AMD64 8.1.0 Build farm viper (FC3, gcc 3.4.2) Fedora x86 8.1.0 Build farm thrush (FC1, gcc 3.3.2) FreeBSD Alpha 7.4 Peter Eisentraut (), 2003-10-25 restored selectively. The following command dumps a database using the custom dump format: pg_dump -Fc dbname > filename A custom-format dump is not a script for psql, but instead must be restored with parts of the database are to be restored. The most flexible output file format is the “custom” format (-Fc). It allows for selection and reordering of all archived items, and is compressed by default. The tar

sha512('abc'::bytea) → \xddaf35a193617abac- c417349ae20413112e6fa4e89a97ea20a9eeee64b55d39a 2192992a274fc1a836ba3c23a3feebbd 454d4423643ce80e2a9ac94fa54ca49f substr ( bytes bytea, start integer [, count restored selectively. The following command dumps a database using the custom dump format: pg_dump -Fc dbname > filename A custom-format dump is not a script for psql, but instead must be restored with 529 | BEGIN 529 0/1689DC0 | 529 | table public.data: INSERT: id[integer]:3 data[text]:'5' 0/1689FC0 | 529 | PREPARE TRANSACTION 'test_prepared1', txid 529 (3 rows) postgres=# COMMIT PREPARED 'test_prepared1';

sha512('abc'::bytea) → \xddaf35a193617abac- c417349ae20413112e6fa4e89a97ea20a9eeee64b55d39a 2192992a274fc1a836ba3c23a3feebbd 454d4423643ce80e2a9ac94fa54ca49f substr ( bytes bytea, start integer [, count restored selectively. The following command dumps a database using the custom dump format: pg_dump -Fc dbname > filename A custom-format dump is not a script for psql, but instead must be restored with 529 | BEGIN 529 0/1689DC0 | 529 | table public.data: INSERT: id[integer]:3 data[text]:'5' 0/1689FC0 | 529 | PREPARE TRANSACTION 'test_prepared1', txid 529 (3 rows) postgres=# COMMIT PREPARED 'test_prepared1';

restored selectively. The following command dumps a database using the custom dump format: pg_dump -Fc dbname > filename A custom-format dump is not a script for psql, but instead must be restored with parts of the database are to be restored. The most flexible output file format is the “custom” format (-Fc). It allows for selection and reordering of all archived items, and is compressed by default. The tar newdb: $ psql -d newdb -f db.sql To dump a database into a custom-format archive file: $ pg_dump -Fc mydb > db.dump To reload an archive file into a (freshly created) database named newdb: $ pg_restore

restored selectively. The following command dumps a database using the custom dump format: pg_dump -Fc dbname > filename A custom-format dump is not a script for psql, but instead must be restored with parts of the database are to be restored. The most flexible output file format is the “custom” format (-Fc). It allows for selection and reordering of all archived items, and is compressed by default. The tar newdb: $ psql -d newdb -f db.sql To dump a database into a custom-format archive file: $ pg_dump -Fc mydb > db.dump 1195 pg_dump To reload an archive file into a (freshly created) database named newdb: