Re: pg_standby stuck on a wal file size <16MB

------=_Part_17262_30342330.1211078386395
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On Sun, May 18, 2008 at 5:48 AM, Vlad Kosilov <vkosilov@[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)
> vkosilov@[EMAIL PROTECTED]
> www.contigo.com
> ________________________________________
>
> --
> Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>



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

EnterpriseDB http://www.enterprisedb.com

Mail sent from my BlackLaptop device

------=_Part_17262_30342330.1211078386395
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On Sun, May 18, 2008 at 5:48 AM, Vlad Kosilov &lt;<a
href="mailto:vkosilov@[EMAIL PROTECTED]
">vkosilov@[EMAIL PROTECTED]
>&gt;
wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt
0.8ex; padding-left: 1ex;">
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?<br></blockquote><div><br>thats a perfectly reasonable
expectation; and thats exactly how it works.<br>
<br></div><blockquote class="gmail_quote" style="border-left: 1px solid
rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left:
1ex;"><br><div class="Ih2E3d"><br>
Ioannis Tambouras wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204,
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><blockquote
class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204);
margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">

 &nbsp;archive_command = &#39;test ! -f /usr/local/wal_archive_local/%f
&amp;&amp; cp %p<br>
 &nbsp;/usr/local/wal_archive_local/%f&#39;<br>
 &nbsp; &nbsp;<br>
</blockquote>
<br>
&nbsp;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&#39;t have sources of pg_standby near me, but I remember in the<br>

C code checks for complete segment sizes.<br>
<br>
<br>
thanks<br>
Ioannis Tambouras<br>
<br>
<br>
 &nbsp;<br>
</blockquote>
<br>
<br>
-- <br></div><div class="Ih2E3d">
________________________________________<br>
Vladimir (Vlad) Kosilov<br>
Senior Systems Administrator<br>
Contigo Systems Inc.<br>
604.683.3106 (phone)<br>
604.648.9886 (fax)<br>
<a href="mailto:vkosilov@[EMAIL PROTECTED]
"
target="_blank">vkosilov@[EMAIL PROTECTED]
><br>
<a href="http://www.contigo.com"
target="_blank">www.contigo.com</a><br>
________________________________________ <br>
<br></div><div><div></div><div class="Wj3C7c">
-- <br>
Sent via pgsql-general mailing list (<a
href="mailto:pgsql-general@[EMAIL PROTECTED]
"
target="_blank">pgsql-general@[EMAIL PROTECTED]
>)<br>
To make changes to your subscription:<br>
<a href="http://www.postgresql.org/mailpref/pgsql-general"
target="_blank">http://www.postgresql.org/mailpref/pgsql-general</a><br>
</div></div></blockquote></div><br><br clear="all"><br>--
<br>gurjeet[.singh]@[EMAIL PROTECTED]
>singh.gurjeet@[EMAIL PROTECTED]
 gmail | hotmail |
indiatimes | yahoo }.com<br><br>EnterpriseDB <a
href="http://www.enterprisedb.com">http://www.enterprisedb.com</a><br>
<br>Mail sent from my BlackLaptop device

------=_Part_17262_30342330.1211078386395--