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

Re: Schema backup - SOLVED

From: "Claudio Lapidus" <clapidus(at)hotmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>,"Peter Eisentraut" <peter_e(at)gmx(dot)net>
Subject: Re: Schema backup - SOLVED
Date: 2003-09-27 12:04:43
Message-ID: BAY7-DAV23IAw19DBqq000013f2@hotmail.com (view raw or flat)
Thread:
Lists: pgsql-general
Tom Lane wrote:
> The proper procedure IMHO would be
> pg_dumpall -s >dumpfile
> psql template1 <dumpfile
>
> There is a small problem with this in 7.3.* (but not before or after):
> due to an oversight, that version of pgdump_all doesn't support the -s
> switch.  So if you are using 7.3 you have to do something like

Ah, ah. That's why it didn't work as I was expecting. This is 7.3.2, yes.
(Peter, this is the 'something' you were asking me to define in your
response. Sorry for not having been more specific the first time.)

>
> pg_dumpall -g >dumpfile
> for each database:
> pg_dump -C -s database >>dumpfile

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

Thanks to all
cl.

In response to

Responses

pgsql-general by date

Next:From: Rasmus AveskoghDate: 2003-09-27 13:11:29
Subject: Result set granularity..
Previous:From: Sven SchwynDate: 2003-09-27 10:51:50
Subject: Modification Dates

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