[postgis-users] database backup?

[Benjamin Wragg]

I think the object creation errors are relating to trying to create some
of the PostGIS objects and functions which are already there. So I don't
think you have to worry, but if I was you I'd do some checking to be
sure.

Cheers,

Benjamin Wragg

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Christoph Spoerri
Sent: Wednesday, 29 October 2003 8:39 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] database backup?


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


_______________________________________________
postgis-users mailing list postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users