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""
--
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
On Wed, Oct 8, 2014 at 1:57 AM, John Scalia <jayknowsunix@xxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
