Re: BAKUP ISSUE

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: BAKUP ISSUE
Дата
Msg-id CAKrjmhcmu6B_CscCSXC2B_LHd8wZGu70mqFQ7y41-rOg9QuNsw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BAKUP ISSUE  (hubert depesz lubaczewski <depesz@gmail.com>)
Ответы Re: BAKUP ISSUE
Re: BAKUP ISSUE
Список pgsql-general
Hi,

First - do not take the messages off list. Someone else might be able to help you if you'll mail to the list, I'm not always there, and others might have better ideas.

On Wed, Jul 9, 2014 at 2:43 PM, Ramesh T <rameshparnanditech@gmail.com> wrote:
 i rune problem is when i run  the pg_stop_backup() its return error  in this way

postgres=# select pg_stop_backup();


NOTICE:  pg_stop_backup cleanup done, waiting for required WAL segments to be ar
chived
WARNING:  pg_stop_backup still waiting for all required WAL segments to be archi
ved (60 seconds elapsed)
HINT:  Check that your archive_command is executing properly.  pg_stop_backup ca
n be canceled safely, but the database backup will not be usable without all the
 WAL segments.

But there is no ERROR?! What error are you talking about?

This is just notice and a warning.
 
i changed in postgresql.conf to archive_command = 'copy "%p" "C:\Program Files\PostgreSQL\ramesh %f"' still working same error return..

What error? So far you didn't show any.

Is the archiving working? Are there files in c:\program files\postgresql\ramesh ?
If not, what does pg logs say about archiving? Any errors there?

depesz

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

Предыдущее
От: M Tarkeshwar Rao
Дата:
Сообщение: Re: Insert query hangs
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Insert query hangs