screwed up authentication

From: "john(dot)tiger" <john(dot)tigernassau(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: screwed up authentication
Date: 2014-06-05 19:24:58
Message-ID: 5390C40A.2090806@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

debian jessie 9.3 latest upgrade

su - postgres
password: xxxxx
==> Authentication failure

edited pg_hba.conf ==> local all all trust
restarted

still failure

sudo -u postgres
pgsql
===> access

okay, figure this is a problem with postgresql user vs linux user - but
how to fix ? is it easier to remove and reinstall postgres ?? or
maybe it is not worth bothering to fix and just use sudo ?

other created users and databases are okay and work from node scripts

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2014-06-05 19:51:10 Re: screwed up authentication
Previous Message Dev Kumkar 2014-06-05 18:46:11 Re: Heartbleed Impact