Re: Upgrading using pg_dumpall

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