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

[Blair Zajac]

Hello,

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?

Regards,
Blair

-- 
Blair Zajac, Ph.D.
<blair at orcaware.com>
Subversion and Orca training and consulting
http://www.orcaware.com/svn/