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