On Jun 5, 2014, at 3:24 PM, "john.tiger" wrote:
> okay, figure this is a problem with postgresql user vs linux user - but how
> to fix ?
John,
su and sudo are OS commands and the examples you provide using them demonstrate
attempts to start a shell as the postgres, OS user. pg_hba.conf is
On 6/5/2014 12:24 PM, john.tiger wrote:
debian jessie 9.3 latest upgrade
su - postgres
password: x
==> Authentication failure
thats the operating system user.to set it, try...
sudo passwd postgres
or, just use sudo as you did later.
edited pg_hba.conf ==> local all all tr
debian jessie 9.3 latest upgrade
su - postgres
password: x
==> 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 ea