[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

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

Re: [GENERAL] screwed up authentication

2014-06-05 Thread Ray Stell
On Jun 5, 2014, at 3:24 PM, john.tiger john.tigernas...@gmail.com 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