From: | akp geek <akpgeek(at)gmail(dot)com> |
---|---|
To: | Gary Chambers <gwchamb(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Grant command help -- postgres |
Date: | 2010-12-01 19:38:38 |
Message-ID: | AANLkTikKk5pW8n-0bpn-XRUxu0rbpVUVTHpdZFBS7SHU@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks for the help. it worked
On Wed, Dec 1, 2010 at 11:10 AM, Gary Chambers <gwchamb(at)gmail(dot)com> wrote:
> akp geek,
>
> > I created a schema , I used pg_restore with postgres as user and restored
> every thing to the new schema I
> > created. Now I want to change the owner ship of the schema and all its
> objects to a different user
> > other than postgres. Is it possible to do that with one command?
>
> In those cases, I will create a user, then create a schema owned by
> that user (and oftentimes remove login privileges if it's mostly
> static):
>
> create user blah encrypted password 'my_password';
> create schema authorization blah;
>
> After that, it's only a matter of executing:
>
> pg_restore -U postgres -n blah -d db yourdumpfile.dmp
>
> This is predicated on having executed pg_dump with the -Fc (custom
> format) option. I haven't tested it with an text dump file.
>
> -- Gary Chambers
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2010-12-01 19:42:40 | Re: Does Postgres support bookmarks (tuples ids)? |
Previous Message | Vick Khera | 2010-12-01 19:14:39 | Re: Cannot start Postgres- FATAL: invalid cache id: 19 |