X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 841EF9FB1B8 for ; Mon, 17 Jul 2006 10:43:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 58711-08 for ; Mon, 17 Jul 2006 13:43:43 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from bay0-omc1-s37.bay0.hotmail.com (bay0-omc1-s37.bay0.hotmail.com [65.54.246.109]) by postgresql.org (Postfix) with ESMTP id 86F429FA506 for ; Mon, 17 Jul 2006 10:43:43 -0300 (ADT) Received: from BAY123-W10 ([207.46.11.45]) by bay0-omc1-s37.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.1830); Mon, 17 Jul 2006 06:43:42 -0700 X-Originating-IP: [213.86.7.252] X-Originating-Email: [rcgeorge23@hotmail.com] Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_f436d64b-652d-4001-aa0d-1d2af1cfab1f_" From: "Richard George" To: "Devrim GUNDUZ" CC: Subject: Re: Changing a database owner on postgres 7.3 Date: Mon, 17 Jul 2006 13:43:42 +0000 X-OriginalArrivalTime: 17 Jul 2006 13:43:42.0028 (UTC) FILETIME=[041D00C0:01C6A9A7] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/139 X-Sequence-Number: 22385 --_f436d64b-652d-4001-aa0d-1d2af1cfab1f_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable thanks for this- worked a treat! > Subject: Re: [ADMIN] Changing a database owner on postgres 7.3> From: dev= rim@commandprompt.com> To: rcgeorge23@hotmail.com> CC: pgsql-admin@postgres= ql.org> Date: Mon, 17 Jul 2006 16:26:00 +0300> > Hi,> > On Mon, 2006-07-17 = at 12:33 +0000, Richard George wrote:> > I've run into trouble attempting t= o change the owner of a particular> > database. The offending line is -> > = > > ALTER DATABASE test OWNER TO epg;> > There is no way to change ownersh= ip 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? > > AFAI= R there is no quick-and-easy way to do that for 7.3. I'd create a> new data= base 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 sup= port> Managed Services, Shared and Dedicated Hosting> Co-Authors: plPHP, pl= PerlNG - http://www.commandprompt.com/> > > > ---------------------------(e= nd of broadcast)---------------------------> TIP 9: In versions below 8.0, = the planner will ignore your desire to> choose an index scan if your= joining column's datatypes do not> match _________________________________________________________________ Be one of the first to try Windows Live Mail. http://ideas.live.com/programpage.aspx?versionId=3D5d21c51a-b161-4314-9b0e-= 4911fb2b2e6d= --_f436d64b-652d-4001-aa0d-1d2af1cfab1f_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable =0A= =0A= =0A= =0A= thanks for this- worked a treat!


> Subject: Re: [ADMIN] Changing a database owner on postgres 7.3
>= From: devrim@commandprompt.com
> To: rcgeorge23@hotmail.com
> = CC: pgsql-admin@postgresql.org
> Date: Mon, 17 Jul 2006 16:26:00 +030= 0
>
> Hi,
>
> On Mon, 2006-07-17 a= t 12:33 +0000, Richard George wrote:
> >&= nbsp;I've run into trouble attempting to chan= ge the owner of a particular
> > dat= abase. The offending line is -
> > &= nbsp;
> > ALTER DATABASE test OWNER TO&nb= sp;epg;
>
> There is no way to change=  ownership of a database with ALTER DATA= BASE in
> 7.3.X . 
>
> > Can = ;someone suggest an alternative way of changi= ng the owner of a
> > database for&n= bsp;7.3? 
>
> AFAIR there is no quick= -and-easy way to do that for 7.3. I'd&nb= sp;create a
> new database with a new u= sername, and I'd use the old database as=  the
> template:
>
> CREATE DATABASE newd= b WITH OWNER newuser TEMPLATE olddb;
>
&= gt; could work for you.
>
> Regards,
> --=  
> The PostgreSQL Company - Command Pr= ompt, Inc. 1.503.667.4564
> PostgreSQL Replication,&nb= sp;Consulting, Custom Development, 24x7 support
>= Managed Services, Shared and Dedicated Hosting> Co-Authors: plPHP, plPerlNG - http://www.commandp= rompt.com/
>
>
>
> ---------------------------(e= nd of broadcast)---------------------------
> TIP 9:&n= bsp;In versions below 8.0, the planner will&n= bsp;ignore your desire to
>     &n= bsp;  choose an index scan if your = joining column's datatypes do not
>   &= nbsp;    match


Be one of the first to tr= y Windows Live Mail.= =0A= = --_f436d64b-652d-4001-aa0d-1d2af1cfab1f_--