On Tue, 2003-08-05 at 11:11, Jimmie H. Apsey wrote:
> Why would you want to do that?
Why would I want to change ownership of a database? I could think of
numerous reasons.
> Why not do it an easier way and dump the database and restore it into
> your new database?
Because that would mean that the database would be down while I did
that. The users to whom I gave ownership to the DB already had
permissions on the tables in the DB. This meant no down time.
> There's got to be a lot of stuff to consider when doing something as
> radical as renaming a database.
I didn't rename any database, nor do anything 'radical'. Please re-read
my message and you'll see.
This SQL query:
UPDATE pg_database SET datdba = 504 WHERE datname='chris';
is obviously simpler than a pg_dump, dropdb, createdb, pg_restore.
Cheers,
Chris
--
Christopher Murtagh
Webmaster / Sysadmin
Web Communications Group
McGill University
Montreal, Quebec
Canada
Tel.: (514) 398-3122
Fax: (514) 398-2017