On Sun, May 18, 2008 at 5:48 AM, Vlad Kosilov <[EMAIL PROTECTED]> wrote:

> is this wrong of me to expect that postgres would not make a wal file
> available to archive_command unless it was completely ready to let go of
> that wal file?
>

thats a perfectly reasonable expectation; and thats exactly how it works.


>
> Ioannis Tambouras wrote:
>
>>  archive_command = 'test ! -f /usr/local/wal_archive_local/%f && cp %p
>>>  /usr/local/wal_archive_local/%f'
>>>
>>>
>>
>>  The archive command tests if the wal segment exists and is a file, but it
>> does not check if the file is still being written. You need to copy the file
>> after writing has finished (it reached 16777216 bytes). I don't have sources
>> of pg_standby near me, but I remember in the
>> C code checks for complete segment sizes.
>>
>>
>> thanks
>> Ioannis Tambouras
>>
>>
>>
>>
>
>
> --
> ________________________________________
> Vladimir (Vlad) Kosilov
> Senior Systems Administrator
> Contigo Systems Inc.
> 604.683.3106 (phone)
> 604.648.9886 (fax)
> [EMAIL PROTECTED]
> www.contigo.com
> ________________________________________
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>



-- 
[EMAIL PROTECTED]
[EMAIL PROTECTED] gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB http://www.enterprisedb.com

Mail sent from my BlackLaptop device

Reply via email to