Horton
Menu

Re: warning message in standby

Kevin Grittner <kevin.grittner@wicourts.gov>

View thread
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Robert Haas" <robertmhaas@gmail.com>
Cc: "Simon Riggs" <simon@2ndquadrant.com>, "Heikki Linnakangas" <heikki.linnakangas@enterprisedb.com>, "Fujii Masao" <masao.fujii@gmail.com>, "Magnus Hagander" <magnus@hagander.net>, "Bruce Momjian" <bruce@momjian.us>, "PostgreSQL-development" <pgsql-hackers@postgresql.org>, "Tom Lane" <tgl@sss.pgh.pa.us>
Date: 2010-06-29T14:58:18Z
Lists: 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