Re: Changing a database owner on postgres 7.3

Hi,

On Mon, 2006-07-17 at 12:33 +0000, Richard George wrote:
> I've run into trouble attempting to change the owner of a particular
> database. The offending line is -
>
> ALTER DATABASE test OWNER TO epg;

There is no way to change ownership of a database with ALTER DATABASE in
7.3.X .

> Can someone suggest an alternative way of changing the owner of a
> database for 7.3?

AFAIR there is no quick-and-easy way to do that for 7.3. I'd create a
new database with a new username, and I'd use the old database as the
template:

CREATE DATABASE newdb WITH OWNER newuser TEMPLATE olddb;

could work for you.

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/