Re: Cannot change archive_command with a reload
| От | CS DBA |
|---|---|
| Тема | Re: Cannot change archive_command with a reload |
| Дата | |
| Msg-id | 52EE6C51.3010708@consistentstate.com обсуждение исходный текст |
| Ответ на | Re: Cannot change archive_command with a reload (Strahinja Kustudić <strahinjak@nordeus.com>) |
| Список | pgsql-admin |
We're running version 9.2.4, on Redhat 5.1
I have tried changing the config file and running "service postgresql-9.2 reload"
I've also tried (as user postgres): pg_ctl -D /var/lib/pgsql/9.2/data reload
no luck with either approach
On 2/2/14, 8:58 AM, Strahinja Kustudić wrote:
I have tried changing the config file and running "service postgresql-9.2 reload"
I've also tried (as user postgres): pg_ctl -D /var/lib/pgsql/9.2/data reload
no luck with either approach
On 2/2/14, 8:58 AM, Strahinja Kustudić wrote:
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 | NordeusOn 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 по дате отправления: