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

Blair Zajac blair at orcaware.com
Sat Nov 12 21:30:36 PST 2005


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.

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?


Blair Zajac, Ph.D.
<blair at orcaware.com>
Subversion and Orca training and consulting

More information about the postgis-users mailing list