Re: screwed up authentication - Mailing list pgsql-general

From Ray Stell
Subject Re: screwed up authentication
Date
Msg-id 22ED9A29-D7F3-43C0-88DF-6D6791BDE5FE@vt.edu
Whole thread Raw
In response to screwed up authentication  ("john.tiger" <john.tigernassau@gmail.com>)
List pgsql-general
On Jun 5, 2014, at 3:24 PM, "john.tiger" <john.tigernassau@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 user.  pg_hba.conf is used to control access to the db, which you are not doing with those commands.  You
havenot demonstrated how you are trying to get access to the db.  The psql command is commonly used for that purpose
andpg_hba.conf would come into play in that case. 

http://www.postgresql.org/docs/9.3/interactive/tutorial-accessdb.html

Regards,
Ray

Attachment

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: screwed up authentication
Next
From: Moshe Jacobson
Date:
Subject: Optimizer issue -- bad query plan?