Received-SPF: pass (google.com: domain of adrian.klaver@gmail.com designates
	10.68.220.67 as permitted sender) client-ip=10.68.220.67;
Message-ID: <4F4FD1AD.90501@gmail.com>
Date: Thu, 01 Mar 2012 11:44:45 -0800
From: Adrian Klaver <adrian.klaver@gmail.com>
User-Agent: Mozilla/5.0 (X11; Linux i686;
	rv:10.0.2) Gecko/20120216 Thunderbird/10.0.2
MIME-Version: 1.0
To: Carlos Mennens <carlos.mennens@gmail.com>
CC: "PostgreSQL (SQL)" <pgsql-sql@postgresql.org>
Subject: Re: Change Ownership Recursively
References: 
 <CAAQLLO7gqap3zYUGGd0fuTZjS8OWt86OUtvNQubLEGf40AyNfA@mail.gmail.com>
	<4F4FA622.70002@affinitas.de>
	<CAAQLLO7W6pAKz26k=JV8W_47O+DT6kOf--U3QKkmgXq_s7LfMw@mail.gmail.com>
	<4F4FC1A1.6070702@gmail.com>
	<CAAQLLO5j9N4FACujBrsnz+aYVV4mYHa8f1TgmLP16AX97Z7qrg@mail.gmail.com>
In-Reply-To: 
 <CAAQLLO5j9N4FACujBrsnz+aYVV4mYHa8f1TgmLP16AX97Z7qrg@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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.mennens@gmail.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.klaver@gmail.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.klaver@gmail.com