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