PgAgent job is not logging errors
От | Jahnavi Chintakunta |
---|---|
Тема | PgAgent job is not logging errors |
Дата | |
Msg-id | 6E38555CD4BF19498F17AE18FEBE5965236B0B1E@INFHYDEXMB.corp.infotech-enterprises.com обсуждение исходный текст |
Список | pgadmin-support |
<div class="WordSection1"><p class="MsoNormal">Hi There,<p class="MsoNormal"> <p class="MsoNormal">We are using PGAgent forscheduling a job which is calling a batch program.(.sh)<p class="MsoNormal"> <p class="MsoNormal">The logic of the batchprogram is to : Reload the postgres setting by using pg_ctl reload command.<p class="MsoNormal"> <p class="MsoNormal">Batchprogram when run from the command prompt is causing the POSTGRES server setting reloaded (i.e SIGHUPsignal is sent to the server).<p class="MsoNormal"> <p class="MsoNormal">However when I include the same program inthe Job step and run the Job from PGAgent, the job status is shown as ‘Successful’ in the ‘status’ window for the PGagentjob but the SIGHUP signal is not sent to the server (This I verified by checking the POSTGRES server log which logsa message when a SIGHUP signal is sent to the server for reloading the settings, but in this case, no such message isbeing written to the server log).<p class="MsoNormal"> <p class="MsoNormal"><b><u>Issue:</u></b><p class="MsoNormal"><b> </b><pclass="MsoNormal"><span style="background:yellow;mso-highlight:yellow">Can you please let meknow 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.</span><p class="MsoNormal"> <p class="MsoNormal">The details of the environmentwith which errors are logged are :<p class="MsoNormal"> <p class="MsoNormal">PGAgent version : pgAgent-3.0.0<pclass="MsoNormal">PGAdmin : 1.12.1<p class="MsoNormal">PostgreSQL : 8.3<p class="MsoNormal"> <p class="MsoNormal">Thanks<pclass="MsoNormal">Jahnavi<p class="MsoNormal"> </div><br /><hr /><font color="Gray" face="Arial"size="1">DISCLAIMER:<br /><br /> This email may contain confidential information and is intended only for theuse of the specific individual(s) to which it is addressed. If you are not the intended recipient of this email, you arehereby notified that any unauthorized use, dissemination or copying of this email or the information contained in it orattached to it is strictly prohibited. If you received this message in error, please immediately notify the sender at Infotechor Mail.Admin@infotech-enterprises.com and delete the original message.<br /></font>
В списке pgadmin-support по дате отправления: