Re: [GENERAL] screwed up authentication

2014-06-05 Thread Ray Stell
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

Re: [GENERAL] screwed up authentication

2014-06-05 Thread John R Pierce
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

[GENERAL] screwed up authentication

2014-06-05 Thread john.tiger
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