Re: Cannot change archive_command with a reload - Mailing list pgsql-admin

From Raghavendra
Subject Re: Cannot change archive_command with a reload
Date
Msg-id CA+h6AhjqPhDSTVuLGypqGmkKoQZHAx7VTMGY-AnnOvtjmxgs1g@mail.gmail.com
Whole thread Raw
In response to Re: Cannot change archive_command with a reload  (CS DBA <cs_dba@consistentstate.com>)
List pgsql-admin

In this case archiver process fail, because there won't be directory called /data/wal_tmp anymore with your your "mv" command.
were moving the file %f not the directory

My bad, I overlooked. Sorry for the inconvenience. 

since both directories are in the same file system the mv is immediate so any process watching for files to show up in /data/wal will never see a partial file


"partial file" ?
Its 16MB file in any case there won't be any partial files, because after completion of writing 16mb file in xlog it will come to archive location else not.
we dont want the log shipper process to ship a file that is still being copied from pg_xlog


What was the previous archive_command string ?

and

ps -ef | grep arch   output?


--Raghav

pgsql-admin by date:

Previous
From: CS DBA
Date:
Subject: Re: HammerDB Error
Next
From: sharon
Date:
Subject: Admin user issue: unable to login after changing password