Hi, you should redirect the output of the pg_dump command to a file to see the error. Do something like: %PGBIN%pg_dump -i -h %PGHOST% -U %PGUSER% -F c -b -v -f "%BACKUPDIR%serverpub-%year%%month%%day%%hh%%nn%.compressed" serverpub* 1> %LOG_FILE% 2>&1*
On 2 March 2017 at 23:04, Rob Musitano <rob.musit...@ldc.com> wrote: > All. > > > > I have a backup job that runs each day yet it shows failed. How can I see > why it failed or where the error is? I searched across PGADMIN and cannot > locate a log that shows me the details. The only location that I see > failed status is at the job in Properties and in the Statistic listing. > Where can I see more of the output or errors that lead to this status. > > > > The job is listed as Routine Maintenance and to get to Success I have ‘On > Error’ temporarily set to ignore. > > > > I’m using pgAdmin 1.14.3 > > PostgreSQL : 9.1.14-1 > > > > Example of my run: > > %PGBIN%pg_dump -i -h %PGHOST% -U %PGUSER% -F c -b -v -f > "%BACKUPDIR%serverpub-%year%%month%%day%%hh%%nn%.compressed" serverpub > > > > Thanks in advance. > > > > Rob > > > > > > > ------------------------------ > > > * CONFIDENTIAL This message and any attachments (the "Message") are > confidential and intended solely for the addressee(s). If you are not the > intended recipient, any use, copying or dissemination is strictly > prohibited. If you are not the intended recipient, please notify the sender > immediately by return and delete this original Message and any copies from > your system. E-mails are susceptible to alteration. Louis Dreyfus Company > BV and its subsidiaries and other affiliates shall not be liable if the > Message is altered, changed or falsified. This is an environment friendly > email. Please do not print it unless it is really necessary. * > -- ------------------------------ Dániel Asztalos developer PUPPETWORKS STUDIOS E-mail: daniel.aszta...@puppetworks.eu Skype: dani.asztalos Mobile: +36 30 875 0727 Phone: +36 1 240 3537 Web: www.puppetworks.eu ------------------------------
