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
I see the pg_user in Section 49.79 but don't know how to correctly configure it. It seems that pg_shadow is unnecessary since I don't need to provide compatibility with versions < 8.1. Rich -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
