| 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: | Whole Thread | Raw Message | 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 |