From: | Strahinja Kustudić <strahinjak(at)nordeus(dot)com> |
---|---|
To: | CS DBA <cs_dba(at)consistentstate(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Cannot change archive_command with a reload |
Date: | 2014-02-02 15:58:43 |
Message-ID: | CADKbJJV8aqiFcxwd80zWWde=1BWZ3aiZDD7ag_M8EMV0vOxZxQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)consistentstate(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
From | Date | Subject | |
---|---|---|---|
Next Message | CS DBA | 2014-02-02 16:03:29 | Re: Cannot change archive_command with a reload |
Previous Message | CS DBA | 2014-02-02 15:52:15 | Cannot change archive_command with a reload |