Re: Streaming replication and postmaster signaling - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Streaming replication and postmaster signaling
Date
Msg-id 16636.1262896348@sss.pgh.pa.us
Whole thread Raw
In response to Re: Streaming replication and postmaster signaling  (Magnus Hagander <magnus@hagander.net>)
Responses Re: Streaming replication and postmaster signaling  (Andrew Dunstan <andrew@dunslane.net>)
Re: Streaming replication and postmaster signaling  (Bruce Momjian <bruce@momjian.us>)
Re: Streaming replication and postmaster signaling  (David Fetter <david@fetter.org>)
List pgsql-hackers
Magnus Hagander <magnus@hagander.net> writes:
> On Thu, Jan 7, 2010 at 21:22, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> No, I don't think so. �HS without SR means you still have to fool with
>> setting up WAL-file-based replication, which despite the existence of
>> pg_standby is a PITA. �And you have to make a tradeoff of how often to
>> flush WAL files to the standby. �To be a real candidate for "it just
>> works" replication, we've *got* to have SR.

> Yes, but HS without SR certainly solves all the "need to offload my
> reporting" kind of situations, which is still a very big thing. Yes,
> it'll be much nicer with SR, but it will be *very* useful without it
> as well.

[ shrug... ]  To me, HS+SR is actual replication, which would justify
tagging this release 9.0.  With only one of them, it's 8.5.  I
understand that there are power users who would find HS alone to be
tremendously useful, but in terms of what the average user sees, there's
a quantum difference.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Streaming replication and postmaster signaling
Next
From: Tom Lane
Date:
Subject: Re: Streaming replication and postmaster signaling