[postgis-users] database backup?

[Heitzso]

Not saying it is the correct way to do it, but my nightly backup script 
line is:
 /usr/local/pgsql/bin/pg_dump gis | bzip2 > /home/backups/gis.sql.bz2

Then I restore by following postgis rules for initializing postgis db then
simple run of the dumped file, i.e. psql [options] < uncompressed.sql

I'll be curious to see critiques of my kludge.

>Hi, 
>
>I'm looking into backing up the postgis database with pg_dump and restoring it 
>with pg_restore. While pg_dump seems to work without any problems, pg_restore 
>is not able to restore the dump file. No matter how I set my restore options 
>(oid order, etc.), the template database is use (template0 or template1), or 
>if I create the postgis objects in advance or not, I always get an Error of 
>missint relations or existing functions (e.g. plpsql_call_handler() ).
>
>I was wondering what solutions/methods some of the list members use to backup 
>their database(s).
>
>thanks in advance,
>Christoph
>  
>