Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42115=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1W9zLQ-0005IQ-JX
 for pgsql-admin@arkaria.postgresql.org; Sun, 02 Feb 2014 15:52:28 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42115=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1W9zLP-0008E9-G3
 for pgsql-admin@arkaria.postgresql.org; Sun, 02 Feb 2014 15:52:27 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <cs_dba@consistentstate.com>) id 1W9zLO-0008Dy-Bh
 for pgsql-admin@postgresql.org; Sun, 02 Feb 2014 15:52:26 +0000
Received: from mail-ig0-f172.google.com ([209.85.213.172])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <cs_dba@consistentstate.com>) id 1W9zLH-0001ND-Ds
 for pgsql-admin@postgresql.org; Sun, 02 Feb 2014 15:52:25 +0000
Received: by mail-ig0-f172.google.com with SMTP id k19so2684259igc.5
 for <pgsql-admin@postgresql.org>; Sun, 02 Feb 2014 07:52:17 -0800 (PST)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
 d=1e100.net; s=20130820;
 h=x-gm-message-state:message-id:date:from:user-agent:mime-version:to
 :cc:subject:content-type:content-transfer-encoding;
 bh=h/fJ9k7I38euhLjXsvfNBrYdWYajEYdYdNNZrAVaQrI=;
 b=dFTX5MaCDlh0REdShFDGvOckvOt+cdPxh8BSTToB9kIgYWWkhKUhRNnoAInQv0lzxS
 jaLbavVAMeWg2eQoa8b6Q9hG3ydwoOLGQfsCMdN1xK0AMuoaBq3EhPomp5+oZ3tqG/Eb
 1sVjzCBHA2naWhctAMVfYwPmYaDW33wxGfspEk/FtdNg9x0RaBvcVdsuWhYy1p0oxKyr
 S9a/8nJ8yTldZcKheyFAo266xMI+qOy3YDdH/d85Z1/kqAPbIoOOB/C0Y5sAti/cZEFg
 Tq/VmuVjJY7WA9RKo0fdAe686Stj+40Cz/EC4LtJxMDgZmZ9hmMraRaL4wKAWldT4Kgi
 AbSA==
X-Gm-Message-State: 
 ALoCoQllova1gGcI5KdhFhgF/uKx4VTVD3pZH2Dx/Xuyisdlg8+HSwRNxkqZ0X1vBMdsRE/JuAvU
X-Received: by 10.50.50.137 with SMTP id c9mr7990660igo.42.1391356337238;
 Sun, 02 Feb 2014 07:52:17 -0800 (PST)
Received: from Kevins-MacBook-Pro.local ([67.148.186.194])
 by mx.google.com with ESMTPSA id h6sm20464340igy.8.2014.02.02.07.52.15
 for <multiple recipients>
 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
 Sun, 02 Feb 2014 07:52:16 -0800 (PST)
Message-ID: <52EE69AF.4030709@consistentstate.com>
Date: Sun, 02 Feb 2014 08:52:15 -0700
From: CS DBA <cs_dba@consistentstate.com>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9;
 rv:24.0) Gecko/20100101 Thunderbird/24.0.1
MIME-Version: 1.0
To: pgsql-admin <pgsql-admin@postgresql.org>
CC: cs_dba@consistentstate.com
Subject: Cannot change archive_command with a reload
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -2.6 (--)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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