| From: | Raghavendra <raghavendra(dot)rao(at)enterprisedb(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 17:04:15 |
| Message-ID: | CA+h6AhgK1fC=n-GBdG6=MxS8PY=iNq7Pxnva+Tcxu8HUmz-=gg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
>
>
> 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.
> 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.
--Raghav
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raghavendra | 2014-02-02 17:06:54 | Re: Cannot change archive_command with a reload |
| Previous Message | Scott Ribe | 2014-02-02 17:03:06 | Re: Cannot change archive_command with a reload |