| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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:
which probably wouldn't be very hard...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2003-09-27 16:40:27 | Is it safe to use DEFAULT currval() |
| Previous Message | Bruce Momjian | 2003-09-27 16:34:54 | Re: initdb failure (was Re: [GENERAL] sequence's plpgsql) |