Re: What may cause - Connection rejected: FATAL: Ident authentication failed for user? - Mailing list pgsql-general

From John Cheng
Subject Re: What may cause - Connection rejected: FATAL: Ident authentication failed for user?
Date
Msg-id 935898.32311.qm@web43413.mail.sp1.yahoo.com
Whole thread Raw
In response to What may cause - Connection rejected: FATAL: Ident authentication failed for user?  (Emi Lu <emilu@encs.concordia.ca>)
List pgsql-general
Check your pg_hba.conf file. What does it look like? The message suggests that your job is trying to connect to the
databaseas the user "schema_owner_name" (or whatever the real user name is), but is actually running as a different
unixuser. Also, did anyone change the unix user running this particular data population job? 


----
John L. Cheng



----- Original Message ----
> From: Emi Lu <emilu@encs.concordia.ca>
> To: pgsql-general@postgresql.org
> Sent: Wednesday, April 22, 2009 6:36:44 AM
> Subject: [GENERAL] What may cause - Connection rejected: FATAL: Ident authentication failed for user?
>
> Good morning,
>
> My daily data population cronjob(around 1 hour) terminated at the middle and
> raised the following error this morning:
>
> Connection rejected: FATAL: Ident authentication failed for user
> "schema_owner_name".
>
> Could anyone tell me what might cause the problem please?
>
>
> Thanks a lot!
> -- Lu Ying
>
> -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general






pgsql-general by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: What may cause - Connection rejected: FATAL: Ident authentication failed for user?
Next
From: Thomas Finneid
Date:
Subject: Re: Yet another "drop table vs delete" question