Re: BAKUP ISSUE

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: BAKUP ISSUE
Дата
Msg-id CAKrjmhcfeAoEzHgmuJgYDuGy3WJ4ADp75Af_iPjPSf2tNT1Wig@mail.gmail.com
обсуждение исходный текст
Список pgsql-general
On Wed, Jul 9, 2014 at 12:45 PM, Ramesh T <rameshparnanditech@gmail.com> wrote:
HI,
          I have a problem when i take backup using pg_basebackup and pg_start_backup('base');
following ,

What is the problem? You didn't write it. Just some outputs and config, but you never mentioned what is the problem itself.
 
archive_mode = on
archive_command = 'copy "%p" "C:\\Program Files\\PostgreSQL\\9.3\\data\\pg_xlog\\%f"'

This archive_command looks bad.

Is c:\program files\postgresql\9.3\data\pg_xlog directory for xlog for THIS postgresql?
If yes - why would you want to copy xlog back to its original location?
If no - while it might work, I don't think it's safe to copy xlogs directly to pg_xlog directory of slave (assuming it's slave).

depesz

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

Предыдущее
От: Spiros Ioannou
Дата:
Сообщение: Re: Largely inconsistent query execution speed, involving psql_tmp
Следующее
От: Francisco Olarte
Дата:
Сообщение: Re: php password authentication failed for user ...