Re: Streaming replication, and walsender during recovery
From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc:
Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>,
Simon Riggs <simon(at)2ndquadrant(dot)com>,
PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Streaming replication, and walsender during recovery
Date:
2010-01-28 15:48:53
Message-ID:
15357.1264693733@sss.pgh.pa.us (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
Fujii Masao <masao(dot)fujii(at)gmail(dot)com> writes:
> 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.
The reason for doing it that way was to limit disk space usage during
a long restore. I'm not convinced we can leave the task to the bgwriter
--- it shouldn't be deleting anything at that point.
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Magnus HaganderDate: 2010-01-28 15:53:44Subject : Re: pgsql: Define INADDR_NONE on Solaris when it's missing.Previous :From : Tom LaneDate : 2010-01-28 15:46:47Subject : Re: pgsql: Define INADDR_NONE on Solaris when it's missing.
