I backed up all my databases using:
pg_dumpall -O -c -U postgres > /tmp/pgalldb2
-O to remove owners on all objects
-c to drop databases before recreating them during the restore to prevent duplicate records
I restored all the databases with this command
psql -U postgres -f /tmp/pgalldb2 postgres
I tried to drop a user but was denied with the message, ". . . some objects depend on it."
Why isn't the -O flag not removing the owner from all objects?
pgsql-admin by date
|Next:||From: Greg Sabino Mullane||Date: 2008-07-24 17:54:31|
|Subject: Re: [ADMIN] shared_buffers and shmmax|
|Previous:||From: Chris Bovitz||Date: 2008-07-24 15:00:00|
|Subject: Upgrade clients when (major) upgrading server?|