Re: Set new owner on cloned database

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