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.