From:
Robert Haas <robertmhaas(at)gmail(dot)com>
To:
Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc:
Simon Riggs <simon(at)2ndquadrant(dot)com>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, Magnus Hagander <magnus(at)hagander(dot)net>, Bruce Momjian <bruce(at)momjian(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject:
Re: warning message in standby
Date:
2010-07-02 21:47:20
Message-ID:
AANLkTimkVIdAZgRgfZZ6BqRn2WFRmJryrFuEY72G_TDO@mail.gmail.com (view raw or flat )
Thread:
2010-06-07 13:21:56 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-06-10 13:57:21 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-10 14:38:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-10 16:01:05 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-06-10 16:13:09 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-10 16:49:28 from Greg Stark <gsstark(at)mit(dot)edu>
2010-06-10 16:54:17 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-11 04:18:54 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-06-11 12:32:27 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-06-11 13:34:48 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-06-11 13:43:48 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-06-11 13:46:24 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-12 01:19:19 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-06-14 06:16:10 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-06-14 10:16:58 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-06-14 10:21:41 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-06-14 11:11:44 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-06-14 11:18:06 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-06-14 11:42:30 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-06-14 14:08:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-14 14:13:12 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-14 14:30:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-14 14:34:05 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-14 14:38:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-14 14:43:38 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-14 14:57:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-14 15:09:17 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-15 02:35:56 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-06-15 03:35:40 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-29 07:55:01 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-06-29 10:59:39 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-29 13:33:20 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-29 14:21:54 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-06-29 14:34:40 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-29 14:58:18 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-07-02 21:47:20 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-30 02:03:38 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-06-30 02:11:06 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-14 18:32:24 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-06-14 14:37:55 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-06-14 14:56:38 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-06-14 15:09:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-14 15:14:38 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-14 15:34:29 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-06-14 15:48:03 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-14 15:38:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-14 16:11:29 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-06-14 16:31:09 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-06-14 16:49:30 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-14 17:00:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-14 17:05:50 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-14 17:38:40 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-06-14 18:22:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-14 18:35:06 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-06-14 18:24:02 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-06-14 18:31:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-14 19:00:23 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-06-14 11:42:55 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-14 11:49:34 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-06-11 12:19:39 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-06-11 13:16:09 from Robert Haas <robertmhaas(at)gmail(dot)com>
Lists:
pgsql-hackers
On Tue, Jun 29, 2010 at 10:58 AM, Kevin Grittner
<Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> Robert Haas <robertmhaas(at)gmail(dot)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.
Drat. It looks like we even recommend that configuration in the docs.
Well, I don't know what to do about this, then, but I predict
somebody's going to get bitten by it... hard.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company
In response to
pgsql-hackers by date
Next :From: Bruce MomjianDate: 2010-07-02 23:20:41Subject : Re: _bt_parent_deletion_safe() isn't safePrevious :From : Robert HaasDate : 2010-07-02 21:44:14Subject : Re: keepalives on MacOS X
