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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
