Lists: | pgsql-admin |
---|
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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: -O not working |
Date: | 2008-07-24 18:01:38 |
Message-ID: | 1216922498.6858.54.camel@jd-laptop |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
On Thu, 2008-07-24 at 10:20 -0700, Marc Fromm wrote:
> 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?
Your problem is likely the -c not the -O. In your target database you
have a role that owns objects. You can't drop a role if it owns objects.
Joshua D. Drake
>
> Marc
>
--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate