From:
Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To:
Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc:
Simon Riggs <simon(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Streaming replication, and walsender during recovery
Date:
2010-01-28 11:40:29
Message-ID:
3f0b79eb1001280340x234d6da5oa683f49d3398e3db@mail.gmail.com (view raw or flat )
Thread:
2010-01-18 05:19:59 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-01-18 14:31:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-18 14:42:43 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-01-19 06:04:06 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-01-19 07:41:10 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-01-20 08:27:49 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-01-28 07:47:13 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-01-28 10:22:36 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-01-28 10:43:17 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-01-28 11:40:29 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-01-28 15:48:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-28 16:22:10 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-01-28 16:41:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-28 17:09:08 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-01-28 17:42:26 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-01-28 17:45:56 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-01-28 18:05:40 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-28 18:29:23 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-01-28 18:37:33 from Greg Smith <greg(at)2ndquadrant(dot)com>
2010-01-28 18:41:35 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2010-01-28 19:16:05 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-01-28 18:49:21 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-01-28 18:58:19 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-01-28 19:00:33 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-01-28 19:13:18 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-01-28 20:05:32 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-01-29 07:49:32 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-01-29 08:22:56 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-01-29 08:31:08 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-01-29 08:41:19 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-01-29 11:25:35 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-01-28 18:40:36 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-02-18 06:23:26 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-03-16 09:11:56 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-03-17 00:29:38 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Lists:
pgsql-hackers
On Thu, Jan 28, 2010 at 7:43 PM, Heikki Linnakangas
<heikki(dot)linnakangas(at)enterprisedb(dot)com> wrote:
> How about restoring/streaming files to a new directory, say
> pg_xlog/restored/, with the real filenames? At least in standby_mode,
> probably best to keep the current behavior in PITR. That would feel more
> clean, you could easily tell apart files originating from the server
> itself and those copied from the master.
When the WAL file with the same name exists in the archive, pg_xlog
and pg_xlog/restore/ which directory should we recover it from?
I'm not sure that we can always make a right decision about that.
How about just making a restore_command copy the WAL files as the
normal one (e.g., 0000...) instead of a pg_xlog/RECOVERYXLOG?
Though we need to worry about deleting them, we can easily leave
the task to the bgwriter.
Regards,
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
In response to
Responses
pgsql-hackers by date
Next :From: Leonardo FDate: 2010-01-28 11:54:21Subject : Re: About "Our CLUSTER implementation is pessimal" patchPrevious :From : Magnus HaganderDate : 2010-01-28 11:36:14Subject : pgsql: Define INADDR_NONE on Solaris when it's missing.
