O'Reilly logo

PostgreSQL 9 Administration Cookbook by Hannu Krosing, Simon Riggs

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Hot logical backup of one database

Logical backup makes a copy of the data in the database by dumping out the contents of each table.

How to do it...

The command to do this is simple and as follows:

pg_dump -F c > dumpfile
or
pg_dump F c f dumpfile

You can also do this through pgAdmin3 as shown in the following screenshot:

How to do it...

How it works...

pg_dump produces a single output file. The output file can use the split(1) command to separate the file into multiple pieces, if required.

pg_dump into custom format is lightly compressed by default. Compression can be removed or made more aggressive.

pg_dump runs by executing SQL statements against the database ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required