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
