On 09/04/2016 07:07 AM, Rich Shepard wrote:
On Sun, 4 Sep 2016, Adrian Klaver wrote:
The above is not possible. If the postmaster was not running there
would be no rejection error.
Adrian,
Yes. I conflated when the postmaster was running -- using the 9.3.4
server
-- and now when it's not running. Now I'm wondering if I mistakenly used
the
-W option to initdb which requires password use for access.
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.
OK. But when I used 'diff -y' I saw only a paragraph of comments as
different. I'll try attaching them; they're ~100 lines each. If the
attachments are stripped off my the mlm I'll list them within the message
body.
Actually there is an important difference. In your 9.3 file you have set
METHOD set to trust and in the 9.5 file it is set to md5, which is
password. Set the METHOD to trust in your 9.5 file and restart the
database. Now for the non-socket access methods this is a security risk,
so you will want to change it back at some point once you get the
users/passwords figured out
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
