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
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 |