[postgis-users] database backup?

[Christoph Spoerri]

This approach seems to work fine and gives me a working database. Yet, during 
the import process (psql ...), I receive multiple errors mainly something 
like 'psql:<stdin>:261037: invalid command \N'. And in the dump file the line 
251037 is just '.\'. Any idea what this is or does?

I also get quite a few object creation errors (mainly related to plpsql and 
postgis objects), yet I assume that I can ignore them. Correct?

Thanks for helping to clear these issues,
Christoph

On Friday 24 October 2003 10:11 am, Heitzso wrote:
> 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
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users