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:19:03
Message-ID: CA+h6AhjqPhDSTVuLGypqGmkKoQZHAx7VTMGY-AnnOvtjmxgs1g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message sharon 2014-02-03 14:26:08 Admin user issue: unable to login after changing password
Previous Message CS DBA 2014-02-02 17:17:22 Re: HammerDB Error