On 09/04/2016 06:26 AM, Rich Shepard wrote:

Ccing list
On Sat, 3 Sep 2016, Adrian Klaver wrote:

Well the pg_dumpall *.sql file has the global
information(users/passwords), so it is a chicken and egg problem.

FYI, you can do:

pg_dumpall -g
https://www.postgresql.org/docs/9.5/static/app-pg-dumpall.html

to get only those globals and then use that to prime the new instance
with that information.

Adrian,

  The postmaster is not running and when I try to connect to a database I'm
asked for my password which is rejected.

The above is not possible. If the postmaster was not running there would be no rejection error.


  I'm thinking what I should do is remove the postgresql-9.5.4 package
(which deletes everything) and re-install it. Since 9.3.4 is not running I
assume that after running initdb I can read the saved pg_dumpall .sql file
and be running 9.5.4 without password requests and rejections.

Don't do that, you will end up right back at this point again. Find the pg_hba.conf files for your 9.5 cluster and your 9.3 cluster and post them here.


Your thoughts, please,

Rich


--
Adrian Klaver
adrian.kla...@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to