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

[strk at refractions.net]

On Sat, Nov 12, 2005 at 09:30:36PM -0800, Blair Zajac wrote:
> 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?

You need -Fc (custom format) for postgis_restore.pl to work.
I dunno if there's a way to produce custom format with pg_dumpall.
If you find it you can try postgis_restore.pl against it, but
I never tested it.

--strk;


 /"\    ASCII Ribbon Campaign
 \ /    Respect for open standards
  X     No HTML/RTF in email
 / \    No M$ Word docs in email