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