What am I missing?
A reproduceable test case.
It is reproduceable for him Peter.
Keith could you provide a little more information?
Who is the user doing the dump?
Who is the user doing the restore?
Are these users superusers?
Either way, my suggestion would be to dump the schema on
Keith C. Perry writes:
> What is a method of dumping and restoring a complete database cluster when that
> cluster contains users that are NOT allowed to create databases.
There is nothing special you need to do, except of course not actually
restoring the dump as one of those unprivileged users.
"Keith C. Perry" <[EMAIL PROTECTED]> writes:
> On the 7.1.3 server:
> pg_dumpall -c > dump.db
You would probably have better luck using the 7.4 installation's pg_dump
and pg_dumpall to extract data from the 7.1 server; there are three
releases worth of bug-fixes in those that are not in the 7.1 du
Quoting Peter Eisentraut <[EMAIL PROTECTED]>:
> Keith C. Perry writes:
>
> > What am I missing?
>
> A reproduceable test case.
>
> --
> Peter Eisentraut [EMAIL PROTECTED]
>
???
Ok, lets try the question this way...
What is a method of dumping and restoring a complete database cluster whe
Keith C. Perry writes:
> What am I missing?
A reproduceable test case.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 8: explain analyze is your friend
