Re: Renaming database

Patrick Robin wrote:
>
> What is the best way to rename a database in Postgres 6.5.

The only documented way is dump and restore.

> Will moving the unix directory work?

No. Moving the directory and updating datname and datpath in pg_database
will. Caveat: In that, you'll inevitably have some period where your
configuration is hosed. Less likely to go wrong would be keeping the old
directory name and only updating datname. YMMV - live surgery on
databases can be useful in emergencies, but it has risks. The only
guaranteed safe procedure is dump and restore!

Sevo

--
sevo@ip23.net