Skip site navigation (1) Skip section navigation (2)

Re: Schema backup - SOLVED

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Claudio Lapidus" <clapidus(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Schema backup - SOLVED
Date: 2003-09-27 16:38:40
Message-ID: 5423.1064680720@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
"Claudio Lapidus" <clapidus(at)hotmail(dot)com> writes:
> Tom Lane wrote:
>> pg_dumpall -g >dumpfile
>> for each database:
>> pg_dump -C -s database >>dumpfile

> That was what we ended up doing. It worked very well.

BTW, if you find yourself wanting to do this a lot, it might be worth
your time to instead fix the oversight in pg_dumpall.  You'd have to
backpatch this fix:

http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/bin/pg_dump/pg_dumpall.c.diff?r1=1.19&r2=1.20

which probably wouldn't be very hard...

			regards, tom lane

In response to

pgsql-general by date

Next:From: Richard HuxtonDate: 2003-09-27 16:40:27
Subject: Is it safe to use DEFAULT currval()
Previous:From: Bruce MomjianDate: 2003-09-27 16:34:54
Subject: Re: initdb failure (was Re: [GENERAL] sequence's plpgsql)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group