On Wed, 8 Dec 2010 13:40:29 -0500 (EST) "James B. Byrne" <byrn...@harte-lyne.ca> wrote:
> I am testing a Rails deployment and wish to copy a database > assigning it an new owner. I have tried this: > > createdb --owner=hll_theheart_db_devl > --template=hll_th_deploytest_prod hll_theheart_devl > > While this indeed sets the database owner to hll_theheart_db_devl > everything else, schema, tables whatever, remains owned by the > original owner. Is there no way to change the owner everywhere in > the cloned database using cretedb? Or am I constrained to do a > dump all and restore? http://www.mail-archive.com/pgsql-hack...@postgresql.org/msg51048.html http://www.mail-archive.com/pgsql-hack...@postgresql.org/msg51047.html I'm not sure if there has been any progress in newer postgres to support easier change of owner. I'm not aware of any more current better solution. Unfortunately I think the license of the above didn't help to make people willing to improve and make the code more popular. -- Ivan Sergio Borgonovo http://www.webthatworks.it -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
