pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRestart or reload after changing the archive_command
6+ messages / 5 participants
[nested] [flat]
* Restart or reload after changing the archive_command
@ 2014-10-07 20:27 John Scalia <jayknowsunix@gmail.com>
0 siblings, 4 replies; 6+ messages in thread
From: John Scalia @ 2014-10-07 20:27 UTC (permalink / raw)
To: pgsql-admin
I've been looking online for an answer, as my test environment is currently unavailable due to an upgrade, but while I know ('cuz it says in the conf file) that a restart is
required when you change "archive_mode", is a restart or a reload required if the "archive_command" is changed? I seem to recall previously that I issued a reload after I changed
this parameter and I saw in the logs that the new value had been recorded, but I'm not certain.
--
Jay
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Restart or reload after changing the archive_command
@ 2014-10-07 20:32 Guillaume Lelarge <guillaume@lelarge.info>
parent: John Scalia <jayknowsunix@gmail.com>
3 siblings, 1 reply; 6+ messages in thread
From: Guillaume Lelarge @ 2014-10-07 20:32 UTC (permalink / raw)
To: John Scalia <jayknowsunix@gmail.com>; +Cc: pgsql-admin
2014-10-07 22:27 GMT+02:00 John Scalia <jayknowsunix@gmail.com>:
> I've been looking online for an answer, as my test environment is
> currently unavailable due to an upgrade, but while I know ('cuz it says in
> the conf file) that a restart is required when you change "archive_mode",
> is a restart or a reload required if the "archive_command" is changed? I
> seem to recall previously that I issued a reload after I changed this
> parameter and I saw in the logs that the new value had been recorded, but
> I'm not certain.
>
You just need a reload.
--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Restart or reload after changing the archive_command
@ 2014-10-07 20:50 John Scalia <jayknowsunix@gmail.com>
parent: Guillaume Lelarge <guillaume@lelarge.info>
0 siblings, 0 replies; 6+ messages in thread
From: John Scalia @ 2014-10-07 20:50 UTC (permalink / raw)
To: Guillaume Lelarge <guillaume@lelarge.info>; +Cc: pgsql-admin
Thanks, Guillaume, I was hoping I remembered that correctly.
On 10/7/2014 4:32 PM, Guillaume Lelarge wrote:
> 2014-10-07 22:27 GMT+02:00 John Scalia <jayknowsunix@gmail.com <mailto:jayknowsunix@gmail.com>>:
>
> I've been looking online for an answer, as my test environment is currently unavailable due to an upgrade, but while I know ('cuz it says in the conf file) that a restart is
> required when you change "archive_mode", is a restart or a reload required if the "archive_command" is changed? I seem to recall previously that I issued a reload after I
> changed this parameter and I saw in the logs that the new value had been recorded, but I'm not certain.
>
>
> You just need a reload.
>
>
> --
> Guillaume.
> http://blog.guillaume.lelarge.info
> http://www.dalibo.com
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Restart or reload after changing the archive_command
@ 2014-10-07 20:54 Shreeyansh dba <shreeyansh2014@gmail.com>
parent: John Scalia <jayknowsunix@gmail.com>
3 siblings, 0 replies; 6+ messages in thread
From: Shreeyansh dba @ 2014-10-07 20:54 UTC (permalink / raw)
To: John Scalia <jayknowsunix@gmail.com>; +Cc: pgsql-admin
If You want to change archive_mode then you need to restart the server &
archive_command need only reload the server.
parameter "archive_mode" cannot be changed without restarting the server
parameter "archive_command" changed to "copy "%p" "D:\arch\%f""
--
Thanks & Regards,
Harshad Adalkonda
Database Administrator
<www.shreeyansh.com>
www.shreeyansh.com
On Wed, Oct 8, 2014 at 1:57 AM, John Scalia <jayknowsunix@gmail.com> wrote:
> I've been looking online for an answer, as my test environment is
> currently unavailable due to an upgrade, but while I know ('cuz it says in
> the conf file) that a restart is required when you change "archive_mode",
> is a restart or a reload required if the "archive_command" is changed? I
> seem to recall previously that I issued a reload after I changed this
> parameter and I saw in the logs that the new value had been recorded, but
> I'm not certain.
> --
> Jay
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Restart or reload after changing the archive_command
@ 2014-10-07 22:43 Ray Stell <stellr@vt.edu>
parent: John Scalia <jayknowsunix@gmail.com>
3 siblings, 0 replies; 6+ messages in thread
From: Ray Stell @ 2014-10-07 22:43 UTC (permalink / raw)
To: John Scalia <jayknowsunix@gmail.com>; +Cc: pgsql-admin
On Oct 7, 2014, at 4:27 PM, John Scalia <jayknowsunix@gmail.com> wrote:
> I've been looking online for an answer
http://www.postgresql.org/docs/9.3/interactive/runtime-config-wal.html#RUNTIME-CONFIG-WAL-ARCHIVING
http://www.postgresql.org/docs/9.3/interactive/runtime-config.html
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Restart or reload after changing the archive_command
@ 2014-10-08 08:12 Albe Laurenz <laurenz.albe@wien.gv.at>
parent: John Scalia <jayknowsunix@gmail.com>
3 siblings, 0 replies; 6+ messages in thread
From: Albe Laurenz @ 2014-10-08 08:12 UTC (permalink / raw)
To: John Scalia *EXTERN* <jayknowsunix@gmail.com>; pgsql-admin
John Scalia wrote:
> I've been looking online for an answer, as my test environment is currently unavailable due to an
> upgrade, but while I know ('cuz it says in the conf file) that a restart is
> required when you change "archive_mode", is a restart or a reload required if the "archive_command" is
> changed? I seem to recall previously that I issued a reload after I changed
> this parameter and I saw in the logs that the new value had been recorded, but I'm not certain.
You already got the answer (reload), but since you mentioned the documentation,
it is a bit tricky in that respect:
If a configuration parameter requires a server restart, the documentation will say
"This parameter can only be set at server start."
Since the archive_command documentation does *not* state that, it can be changed
with a reload.
Yours,
Laurenz Albe
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2014-10-08 08:12 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-10-07 20:27 Restart or reload after changing the archive_command John Scalia <jayknowsunix@gmail.com>
2014-10-07 20:32 ` Guillaume Lelarge <guillaume@lelarge.info>
2014-10-07 20:50 ` John Scalia <jayknowsunix@gmail.com>
2014-10-07 20:54 ` Shreeyansh dba <shreeyansh2014@gmail.com>
2014-10-07 22:43 ` Ray Stell <stellr@vt.edu>
2014-10-08 08:12 ` Albe Laurenz <laurenz.albe@wien.gv.at>
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