[postgis-users] database backup?

[Christoph Spoerri]

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


-- 
Christoph Spoerri
Associate in Research 
A321 LSRC, Box 90328
Nicholas School of the Environment and Earth Sciences
Duke University
Durham, NC 27708
phone: 919-613-8119
fax: 919-684-8741
http://www.env.duke.edu