From: CS DBA <cs_dba@consistentstate.com>
To: Raghavendra <raghavendra.rao@enterprisedb.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Cannot change archive_command with a reload
Date: Sun, 02 Feb 2014 10:08:09 -0700
Message-ID: <52EE7B79.3070009@consistentstate.com> (raw)
In-Reply-To: <CA+h6AhgK1fC=n-GBdG6=MxS8PY=iNq7Pxnva+Tcxu8HUmz-=gg@mail.gmail.com>
References: <52EE69AF.4030709@consistentstate.com>
<CA+h6AhgvJTdb41peyGFeOnpigG6uzJQbH7iZaDRfoWuT+wQ+YA@mail.gmail.com>
<52EE71B9.3090204@consistentstate.com>
<CA+h6Ahhu+PRLWjQeHCSwmKKk1UuSj-aiqK0cmqRzeSw9gojFsg@mail.gmail.com>
<52EE78EA.7070801@consistentstate.com>
<CA+h6AhgK1fC=n-GBdG6=MxS8PY=iNq7Pxnva+Tcxu8HUmz-=gg@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: cs_dba@consistentstate.com, raghavendra.rao@enterprisedb.com
Subject: Re: Cannot change archive_command with a reload
In-Reply-To: <52EE7B79.3070009@consistentstate.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox