On Sun, 4 Sep 2016, Charles Clavadetscher wrote:
Are you able to connect to the new instance with any user at all, e.g. with psql? If so you can use the command \du to list all users.
Charles, No. The postmaster is not running; trying to start it requires a password which is also rejected. Since I have the pg_dumpall data in a large .sql file I think the best solution is for me to remove the 9.5.4 package completely, re-install from the package tarball, run initdb, then start the postmaster and restore all the databases in the cluster. I'm thinking that without paying attention when I initially ran initdb I used a commandline found on a web site (rather than just reading the man page) and used the -W option which requires a password for everything. So starting over from scratch _should_ remove all issues and successfully end this thread. Thanks, Rich -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general