Re: Schema backup - SOLVED

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.