Le 08/12/2010 22:41, Ivan Sergio Borgonovo a écrit : > 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?
No, you can't. --owner changes only the owner of the database. >> 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. > You should try REASSIGN OWNED BY. See http://www.postgresql.org/docs/9.0/interactive/sql-reassign-owned.html -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
