Re: warning message in standby - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: warning message in standby
Date
Msg-id 4C29C3BA0200002500032CDC@gw.wicourts.gov
Whole thread Raw
In response to Re: warning message in standby  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: warning message in standby
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> wrote:
>> If someone is sloppy about how they copy the WAL files around,
>> they could temporarily have a truncated file.
> 
> Can you explain the scenario you're concerned about in more
> detail?
If someone uses cp or scp to copy a WAL file from the pg_xlog
directory to an archive directory, there will be a window of time
where the file exists and is not complete.  If you wait "a while"
(that being a duration which could be highly variable, depending on
the specifics of the environment and copy techniques used), the
missing part of the file will materialize.
-Kevin


pgsql-hackers by date:

Previous
From: Thom Brown
Date:
Subject: Re: Look-behind regular expressions
Next
From: Tom Lane
Date:
Subject: Re: Keepalives win32