pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gowri Sivaraman <gsivaraman@magnasync.com>
To: pgsql-admin@postgresql.org
Subject: pg_hba.conf
Date: Tue, 21 Feb 2006 11:39:38 -0800
Message-ID: <229be82fef34690094034e04c7c4e0fd@magnasync.com> (raw)

Hi,
   I am having problems with my connectivity for any of the users other 
than the post gres. Let me elaborate on the situation


I am using OSX and i have changed the pg_hba.conf file to reflect 
ident_authentication. I have attached my pg_hba.conf file. When i try 
connecting as a user i get the following error


Gowri-Sivaraman:~ gowri$ psql -h localhost gen3logger
psql: FATAL:  Ident authentication failed for user "gowri"


Even when i have given the user gowri trust authorization, it is not 
working. For some reason, it is recognizing local . when i connect 
using the host it is working. Can anybody let me know if i am missing 
something here


Gowri-Sivaraman:~ gowri$ psql -h 127.0.0.1 -U gowri template1
Welcome to psql 8.1.3, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
        \h for help with SQL commands
        \? for help with psql commands
        \g or terminate with semicolon to execute query
        \q to quit

SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)

template1=>




Thanks
Gowri

Attachments:

  pg_hba.conf (application/octet-stream, 8.3K) download

view thread (53+ messages)  latest in thread

Message-ID: <229be82fef34690094034e04c7c4e0fd@magnasync.com>
Permalink:  ../229be82fef34690094034e04c7c4e0fd@magnasync.com/
Also on:    postgresql.org/message-id/229be82fef34690094034e04c7c4e0fd@magnasync.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: gsivaraman@magnasync.com
  Subject: Re: pg_hba.conf
  In-Reply-To: <229be82fef34690094034e04c7c4e0fd@magnasync.com>
  References: <229be82fef34690094034e04c7c4e0fd@magnasync.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox