Re: Version upgrade: is restoring the postgres database needed?

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.