Skip site navigation (1) Skip section navigation (2)

-O not working

From: Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: -O not working
Date: 2008-07-24 17:20:56
Message-ID: B0D7C0A3F35FE144A70312D086CBCA9B0CF2B321@ExchMailbox2.univ.dir.wwu.edu (view raw or flat)
Thread:
Lists: pgsql-admin
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

Responses

pgsql-admin by date

Next:From: Greg Sabino MullaneDate: 2008-07-24 17:54:31
Subject: Re: [ADMIN] shared_buffers and shmmax
Previous:From: Chris BovitzDate: 2008-07-24 15:00:00
Subject: Upgrade clients when (major) upgrading server?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group