Cannot change archive_command with a reload

From: CS DBA <cs_dba(at)consistentstate(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Cc: cs_dba(at)consistentstate(dot)com
Subject: Cannot change archive_command with a reload
Date: 2014-02-02 15:52:15
Message-ID: 52EE69AF.4030709@consistentstate.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Strahinja Kustudić 2014-02-02 15:58:43 Re: Cannot change archive_command with a reload
Previous Message Sergey Konoplev 2014-02-01 00:43:14 Re: odd pg_start_backup() issue