Re: screwed up authentication

From: Ray Stell <stellr(at)vt(dot)edu>
To: "john(dot)tiger" <john(dot)tigernassau(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: screwed up authentication
Date: 2014-06-05 21:07:39
Message-ID: 22ED9A29-D7F3-43C0-88DF-6D6791BDE5FE@vt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Jun 5, 2014, at 3:24 PM, "john.tiger" <john(dot)tigernassau(at)gmail(dot)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 have not demonstrated how you are trying to get access to the db. The psql command is commonly used for that purpose and pg_hba.conf would come into play in that case.

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

Regards,
Ray

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Moshe Jacobson 2014-06-05 21:43:00 Optimizer issue -- bad query plan?
Previous Message John R Pierce 2014-06-05 19:51:10 Re: screwed up authentication