From: | CS DBA <cs_dba(at)consistentstate(dot)com> |
---|---|
To: | Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Cannot change archive_command with a reload |
Date: | 2014-02-02 17:08:09 |
Message-ID: | 52EE7B79.3070009@consistentstate.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On 2/2/14, 10:04 AM, Raghavendra wrote:
>
>
> My issue is the &f instead of %f at the end. However here's the
> intent:
>
> if the first command is true (cp %p /data/wal_tmp/%f) then I want
> the second command to execute (mv /data/wal_tmp/%f /data/wal/%f)
>
>
> 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
> 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
>
> --Raghav
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | deepak | 2014-02-02 17:11:42 | Re: Cannot change archive_command with a reload |
Previous Message | Raghavendra | 2014-02-02 17:06:54 | Re: Cannot change archive_command with a reload |