Re: What may cause - Connection rejected: FATAL: Ident authentication failed for user?

Check your pg_hba.conf file. What does it look like? The message suggests that your job is trying to connect to the database as the user "schema_owner_name" (or whatever the real user name is), but is actually running as a different unix user. Also, did anyone change the unix user running this particular data population job?

----
John L. Cheng

----- Original Message ----
> From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
> To: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general