PgAgent job is not logging errors

From: Jahnavi Chintakunta <Jahnavi(dot)Chintakunta(at)infotech-enterprises(dot)com>
To: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: PgAgent job is not logging errors
Date: 2011-03-29 09:38:33
Message-ID: 6E38555CD4BF19498F17AE18FEBE5965236B0B1E@INFHYDEXMB.corp.infotech-enterprises.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi There,

We are using PGAgent for scheduling a job which is calling a batch program.(.sh)

The logic of the batch program is to : Reload the postgres setting by using pg_ctl reload command.

Batch program when run from the command prompt is causing the POSTGRES server setting reloaded (i.e SIGHUP signal is sent to the server).

However when I include the same program in the Job step and run the Job from PGAgent, the job status is shown as 'Successful' in the 'status' window for the PGagent job but the SIGHUP signal is not sent to the server (This I verified by checking the POSTGRES server log which logs a message when a SIGHUP signal is sent to the server for reloading the settings, but in this case, no such message is being written to the server log).

Issue:

Can you please let me know if PGAgent logs any errors if there are any issues with the jobs executed.. Why is the job status shown as 'Successful' even though nothing happened.

The details of the environment with which errors are logged are :

PGAgent version : pgAgent-3.0.0
PGAdmin : 1.12.1
PostgreSQL : 8.3

Thanks
Jahnavi

________________________________
DISCLAIMER:

This email may contain confidential information and is intended only for the use of the specific individual(s) to which it is addressed. If you are not the intended recipient of this email, you are hereby notified that any unauthorized use, dissemination or copying of this email or the information contained in it or attached to it is strictly prohibited. If you received this message in error, please immediately notify the sender at Infotech or Mail(dot)Admin(at)infotech-enterprises(dot)com and delete the original message.

Browse pgadmin-support by date

  From Date Subject
Next Message Dhedik Heriyanto 2011-03-30 03:53:25 Password
Previous Message Evan Zeimet 2011-03-28 13:18:48 pgAdmin 1.2.2 on W7 - Editor won't open