[postgis-users] pg_dump -Fc vs pg_dumpall for daily backups

Markus Schaber schabi at logix-tt.com
Mon Nov 14 01:42:48 PST 2005

Hi, Blair,

Blair Zajac wrote:

> Being new to PostGIS and reading the README, it says that one shold
> use 'pg_dump -Fc' to do a dump that is given to
> 'utils/postgis_restore.pl' to upgrade PostGIS.

Yes, that's right.

> However, for doing just daily backups and recovering a box that
> crashed (say you lost a disk) and you want to do a full restore into
> a freshy init'ed PostgreSQL database, does pg_dumpall work?  Or does
> one always need to use pg_dump -Fc for any database with geographic
> columns?

It should work if you are reloading into the same PostgreSQL version
into a freshly init'ed cluster, and the pg_library_path is compatible.

It is possible that you need to bring the template0/template1 databases
in sync before replaying if you changed them in the original cluster (as
pg_dump etc. use them as reference).


More information about the postgis-users mailing list