Re: Change Ownership Recursively

On 03/01/2012 11:37 AM, Carlos Mennens wrote:
> I changed to the suggested database which is owned by 'Carlos' and did
> as instructed. Everything worked fine. Thank you!

In your previous post my guess is this:

iamunix=# \c postgres

was really meant to be:

iamunix=# \c - postgres

The first changes to database postgres as current user, the second
changes the user while remaining on the current database.

>
> On Thu, Mar 1, 2012 at 11:23 AM, Carlos Mennens
> <carlos(dot)mennens(at)gmail(dot)com> wrote:
>> I did do a Google search for "PostgreSQL 9.1 change ownership
>> recursively" but either couldn't find what I was looking for or
>> missed it.
>
> On Thu, Mar 1, 2012 at 1:36 PM, Adrian Klaver<adrian(dot)klaver(at)gmail(dot)com> wrote:
>> For future reference including the Postgres version would be
>> helpful. This area ownership/grants/etc has undergone a lot of changes over
>> the various versions.
>
> I specified above I was using 9.1 PostgreSQL.

Oops, my mistake, I never got to the PS:(

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com