From: Hannu Krosing <hannu@2ndQuadrant.com>
To: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: postgres hackers <pgsql-hackers@postgresql.org>
Subject: Re: Simplifying replication
Date: Sat, 06 Nov 2010 20:22:16 +0200
Message-ID: <1289067736.2313.1896.camel@hvost> (raw)
In-Reply-To: <m2pquicrn1.fsf@2ndQuadrant.fr>
References: <4CBCE356.2080703@agliodbs.com>
<m28w1ushwz.fsf@2ndQuadrant.fr>
<1288996741.2313.370.camel@hvost>
<m2pquicrn1.fsf@2ndQuadrant.fr>
On Sat, 2010-11-06 at 18:02 +0100, Dimitri Fontaine wrote:
> Hannu Krosing <hannu@2ndQuadrant.com> writes:
> > To make pg_basebackup.py self-sufficient it should also open 2nd
> > connection to the same master and make sure that all WAL files are
> > copied for the duration of base copy.
>
> Excellent idea, will make that happen soon'ish.
Unitil I learned better, I thought that this is how SR is supposed to works ;)
btw, as next step you could backport this to 8.x and have most of the
benefits of SR. It should not be very hard to keep track of wal position
inside a pl/pythonu function and send one or more records back in form of
(walfile_name text, start_pos int, data bytea)
and then call this function from client every second to keep possible data
loss down to 1 sec.
this lets you set up warm standby with nothing more than a postgresql
superuser access to master (assuming right defaults in postgresql conf).
--
-------
Hannu Krosing
PostgreSQL Infinite Scalability and Preformance Consultant
PG Admin Book: http://www.2ndQuadrant.com/books/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: hannu@2ndQuadrant.com, dimitri@2ndQuadrant.fr, josh@agliodbs.com
Subject: Re: Simplifying replication
In-Reply-To: <1289067736.2313.1896.camel@hvost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox