Re: Upgrading using pg_dumpall

On Sun, 4 Sep 2016, Adrian Klaver wrote:

> -W is not referring to the OS user but the database superuser. Now in your
> case they have the same name, postgres. The settings in /etc/passwd are
> not relevant to what -W is doing. -W is referring to user information
> being stored in the cluster in the system tables pg_user and pg_shadow:
>
> https://www.postgresql.org/docs/9.5/static/catalogs.html

Adrian,

   I did not know this. Thanks for the information.

Rich