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.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
