On Wed, 8 Dec 2010 13:40:29 -0500 (EST)
"James B. Byrne" <byrnejb@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-hackers@postgresql.org/msg51048.htmlhttp://www.mail-archive.com/pgsql-hackers@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
