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 <em...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
