Re: [pgadmin-support] Failed backup Job. How to find out why it failed.

Поиск
Список
Период
Сортировка
От Dániel Asztalos
Тема Re: [pgadmin-support] Failed backup Job. How to find out why it failed.
Дата
Msg-id CADV9uEaX6iTZ4pF_iTV9CrfwXCxXAN4edfjBPz5QfTxSA5XMqw@mail.gmail.com
обсуждение исходный текст
Ответ на [pgadmin-support] Failed backup Job. How to find out why it failed.  (Rob Musitano <Rob.Musitano@LDC.com>)
Ответы Re: [pgadmin-support] Failed backup Job. How to find out why itfailed.  (Rob Musitano <Rob.Musitano@LDC.com>)
Список pgadmin-support
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.Musitano@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.asztalos@puppetworks.eu
Skype: dani.asztalos
Mobile: +36 30 875 0727
Phone: +36 1 240 3537
Web: www.puppetworks.eu


В списке pgadmin-support по дате отправления:

Предыдущее
От: Rob Musitano
Дата:
Сообщение: [pgadmin-support] Failed backup Job. How to find out why it failed.
Следующее
От: Daniel Küppers
Дата:
Сообщение: [pgadmin-support] unable to restore database