[postgis-users] database backup?

[Christoph Spoerri]

Thanks for the help. The psql actually worked. I got some errors during 
loading, but the DB seems to be in order and workable.

Now, I have two more questions (not urgent, but still worth discussing)

1) what do you do if you have objects (blobs) in the database. In this case 
you can't use the psql export, since it does only support the '-F p' options 
(if I'm correct).

2) How do you back up a 100GB+ database? Split the static and dynamic data 
into two separate databases, and back up only the dynamic nightly?


Btw. Anybody interested to write up some HOWTO on backing up a postgis 
database? I'm not an expert on Postgesql so some help from an expert would be 
great. And it would be a nice thing to have in the documentation. let me 
know.

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