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?
Thanks
Marc
