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
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
