Change ownership of a database

From: Kevin Duffy <kevind0718(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Change ownership of a database
Date: 2017-02-09 02:33:30
Message-ID: CAHCyeW052x3hZJcBVX=kyb+zAnvF78i9aQba7BByo7J3saHnrw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Steve Crawford 2017-02-09 04:17:38 Re: Change ownership of a database
Previous Message Ganesh Kannan 2017-02-08 20:56:11 Re: Recovery from Transaction wraparound failure