Re: Changing DB ownership

Why would you want to do that?

Why not do it an easier way and dump the database and restore it into
your new database?

There's got to be a lot of stuff to consider when doing something as
radical as renaming a database.

I am a developer of dental computer systems using Postgres within Red
Hat Advanced Server 2.1.

Jim Apsey

Christopher Murtagh wrote:

> Dumb question maybe, but how does one change database ownership? I've
>tried several permutations of:
>
>ALTER DATABASE SET ("|'| )owner("|'| ) TO ("|'| )newowner("|'| );
>
>and I tried looking at pg_database and I *was* able to hack this (got a
>clue half way through writing this email... sorry):
>
>UPDATE pg_database SET datdba = 504 WHERE datname='chris';
>
>And that worked as expected, but I'm worried that I might have missed
>something somewhere else. Will the above UPDATE cause problems down the
>road?
>
>Any info/clue would be much appreciated. Thanks in advance.
>
>Cheers,
>
>Chris
>
>---------------------------(end of broadcast)---------------------------
>TIP 7: don't forget to increase your free space map settings
>
>
>