Re: Cannot change archive_command with a reload

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: Raw Message | Whole Thread | 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

In response to

Responses

Browse pgsql-admin by date

  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