Re: Core team statement on replication in PostgreSQL - Mailing list pgsql-hackers

From Shane Ambler
Subject Re: Core team statement on replication in PostgreSQL
Date
Msg-id 483EE3AC.9050309@Sheeky.Biz
Whole thread Raw
In response to Re: Core team statement on replication in PostgreSQL  (David Fetter <david@fetter.org>)
List pgsql-hackers
David Fetter wrote:

> This part is a deal-killer.  It's a giant up-hill slog to sell warm
> standby to those in charge of making resources available because the
> warm standby machine consumes SA time, bandwidth, power, rack space,
> etc., but provides no tangible benefit, and this feature would have
> exactly the same problem.
> 
> IMHO, without the ability to do read-only queries on slaves, it's not
> worth doing this feature at all.

+1

I would think that a read-only WAL slave is more valuable than a 
real-time backup. (especially as the topic is about adding slaves not 
increasing the effectiveness of backups)


I also think that starting with a read-only WAL slave will ease the 
transition between delayed slave updating and real-time slave updating.


-- 

Shane Ambler
pgSQL (at) Sheeky (dot) Biz

Get Sheeky @ http://Sheeky.Biz


pgsql-hackers by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Duplicate Key Error from ANALYZE
Next
From: Tom Lane
Date:
Subject: Re: Core team statement on replication in PostgreSQL