From: Scott Marlowe <scott.marlowe@gmail.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: postgresql.20.j_random_hacker@spamgourmet.com
Cc: pgsql-admin@postgresql.org
Subject: Re: Proposal for restoring a dump into a database with a different owner
Date: Mon, 30 Jun 2008 14:01:36 -0600
Message-ID: <dcc563d10806301301q1fd902b6qed52671352a41523@mail.gmail.com> (raw)
In-Reply-To: <200806301950.m5UJo6p03894@momjian.us>
References: <000301c8b28a$d8d15e90$959c7b82@massey.ac.nz>
<200806301950.m5UJo6p03894@momjian.us>
On Mon, Jun 30, 2008 at 1:50 PM, Bruce Momjian <bruce@momjian.us> wrote:
>
> I see you didn't get a response this request. I am thinking it would be
> better to implement some form of massive change ownership option that
> can be done to change ownership after the dump is restored.
Currently the way I do that is to dump with the -O option, and then
restore to the user account I want everything to belong to.
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-admin@postgresql.org
Cc: scott.marlowe@gmail.com, bruce@momjian.us, postgresql.20.j_random_hacker@spamgourmet.com
Subject: Re: Proposal for restoring a dump into a database with a different owner
In-Reply-To: <dcc563d10806301301q1fd902b6qed52671352a41523@mail.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