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
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