Re: Changing database owner (7.4)

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Changing database owner (7.4)
Date: 2005-12-05 23:19:33
Message-ID: 4394CB05.1020709@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Steve Crawford wrote:
> Changing the owner of a database is easy in 8.x (alter database...)
> but seems less so in 7.4.
>
> Is there a method of safely changing the owner of the database (via
> command or via updating pg* tables) in 7.4?
>
Use a transaction and use update to pg_database

Joshua D. Drake

> Cheers,
> Steve
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Crawford 2005-12-05 23:45:39 Re: Changing database owner (7.4)
Previous Message Andreas Pflug 2005-12-05 23:19:31 Re: [GENERAL] Missing variable "role" in "pg_settings"?