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

From: Ioannis Tambouras <ioannis(at)akroninc(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_standby stuck on a wal file size <16MB
Date: 2008-05-17 23:07:21
Message-ID: 20080517230721.GA4812@akroninc.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vlad Kosilov 2008-05-18 00:11:21 Re: pg_standby stuck on a wal file size <16MB
Previous Message Christian.Strobl 2008-05-17 20:05:19 WG: [GENERAL] reproducible database crash with simple sql command on postgres 8.3.1