Home > mailing lists

[ADMIN] Change ownership of a database - Mailing list pgsql-admin

From	Kevin Duffy
Subject	[ADMIN] Change ownership of a database
Date	February 9, 2017 08:33:30
Msg-id	CAHCyeW052x3hZJcBVX=kyb+zAnvF78i9aQba7BByo7J3saHnrw@mail.gmail.com Whole thread Raw
Responses	Re: [ADMIN] Change ownership of a database (Steve Crawford <scrawford@pinpointresearch.com>) Re: [ADMIN] Change ownership of a database (Jorge Torralba <jorge.torralba@gmail.com>)
List	pgsql-admin

Hello all:

I made a mistake. Maybe I was lazy.

I created a database and did some amount of development as postgres.

Now I need to get this changed to a log-on role say xxx-db-owner.

I have a bunch of tables , functions and user defined types.

I have created the role: xxx-db-owner.

And most important I have db backups and have a copy of the db on the server under a different name.

And I have written the sql to to the changes for the tables, functions and user defined types.

Question: the database and schema ownership needs to be changed also?

Is there an order I should do the changes in?

Is there a way I can shoot myself in the foot here.

Many thanks for your attention to this matter.

KBD

From: Ganesh Kannan
Date: 09 February 2017, 02:56:11
Subject: Re: [ADMIN] Recovery from Transaction wraparound failure

From: Steve Crawford
Date: 09 February 2017, 10:17:38
Subject: Re: [ADMIN] Change ownership of a database