From: Adrian Klaver <adrian.klaver@gmail.com>
To: Carlos Mennens <carlos.mennens@gmail.com>
Cc: PostgreSQL (SQL) <pgsql-sql@postgresql.org>
Subject: Re: Change Ownership Recursively
Date: Thu, 01 Mar 2012 11:44:45 -0800
Message-ID: <4F4FD1AD.90501@gmail.com> (raw)
In-Reply-To: <CAAQLLO5j9N4FACujBrsnz+aYVV4mYHa8f1TgmLP16AX97Z7qrg@mail.gmail.com>
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: adrian.klaver@gmail.com, carlos.mennens@gmail.com
Subject: Re: Change Ownership Recursively
In-Reply-To: <4F4FD1AD.90501@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox