Re: Version upgrade: is restoring the postgres database needed?
| От | Vick Khera |
|---|---|
| Тема | Re: Version upgrade: is restoring the postgres database needed? |
| Дата | |
| Msg-id | CALd+dceeexyKCjPh3dN7o=bp43Zgjtt9SUoWPU6bMz9xDG9KjA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Version upgrade: is restoring the postgres database needed? (Ron Johnson <ron.l.johnson@cox.net>) |
| Список | pgsql-general |
On Thu, Mar 1, 2018 at 11:51 AM, Ron Johnson <ron.l.johnson@cox.net> wrote:
Good. What, then, have I forgotten to restore such that the "Access privileges" are showing on my current 9.2 servers, but not on the newly-restored 9.6.6 server?
Current
postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-------------+----------+----------+-------------+---------- ---+-----------------------
CSSCAT_STI | CSS | UTF8 | en_US.UTF-8 | en_US.UTF-8 | CSS=CTc/CSS +
| | | | | =Tc/CSS +
| | | | | app_user=CTc/CSS
CSSCAT_STIB | CSS | UTF8 | en_US.UTF-8 | en_US.UTF-8 | CSS=CTc/CSS +
| | | | | =Tc/CSS +
| | | | | app_user=CTc/CSS
CSSCAT_STIC | CSS | UTF8 | en_US.UTF-8 | en_US.UTF-8 | CSS=CTc/CSS +
| | | | | =Tc/CSS +
| | | | | app_user=CTc/CSS
Newly restored
postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-------------+----------+----------+-------------+---------- ---+-----------------------
CSSCAT_STIB | CSS | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
CSSCAT_STIC | CSS | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
FWIW none of my databases other than template0 and template1 have anything listed for Access privileges like that. I'm not even sure exactly what those are for :(
Any privileges from REVOKEs and GRANTs will be in the dump, so those are restored.
В списке pgsql-general по дате отправления: