From: CS DBA <cs_dba@consistentstate.com>
To: Strahinja Kustudić <strahinjak@nordeus.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Cannot change archive_command with a reload
Date: Sun, 02 Feb 2014 09:03:29 -0700
Message-ID: <52EE6C51.3010708@consistentstate.com> (raw)
In-Reply-To: <CADKbJJV8aqiFcxwd80zWWde=1BWZ3aiZDD7ag_M8EMV0vOxZxQ@mail.gmail.com>
References: <52EE69AF.4030709@consistentstate.com>
<CADKbJJV8aqiFcxwd80zWWde=1BWZ3aiZDD7ag_M8EMV0vOxZxQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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:
> 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
> <mailto: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
> <mailto:pgsql-admin@postgresql.org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: cs_dba@consistentstate.com, strahinjak@nordeus.com
Subject: Re: Cannot change archive_command with a reload
In-Reply-To: <52EE6C51.3010708@consistentstate.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox