Re: Cannot change archive_command with a reload

Поиск
Список
Период
Сортировка
От Strahinja Kustudić
Тема Re: Cannot change archive_command with a reload
Дата
Msg-id CADKbJJV8aqiFcxwd80zWWde=1BWZ3aiZDD7ag_M8EMV0vOxZxQ@mail.gmail.com
обсуждение исходный текст
Ответ на Cannot change archive_command with a reload  (CS DBA <cs_dba@consistentstate.com>)
Ответы Re: Cannot change archive_command with a reload
Список pgsql-admin
Дерево обсуждения
What version of Postgres are you using? What OS? Have you tried editing the archive_command in postgresql.conf and then reload?

Strahinja Kustudić | Lead System Engineer | Nordeus


On Sun, Feb 2, 2014 at 4:52 PM, CS DBA <cs_dba@consistentstate.com> wrote:
Hi all;

we have a cluster running with an archive command that is failing.
I tried a reload and the value does not change

Tried a set_config and I get this error:

select set_config ('archive_command', 'cp %p /data/wal_tmp/%f && mv /data/wal_tmp/%f /data/wal/&f', 'false');
ERROR:  parameter "archive_command" cannot be changed now


Thoughts?

Thanks in advance


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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

Предыдущее
От: CS DBA
Дата:
Сообщение: Cannot change archive_command with a reload
Следующее
От: CS DBA
Дата:
Сообщение: Re: Cannot change archive_command with a reload