Hot standby & SR - log shipping required?

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: 'PostgreSQL' <pgsql-general(at)postgresql(dot)org>
Subject: Hot standby & SR - log shipping required?
Date: 2013-09-13 19:51:47
Message-ID: 52336CD3.4020103@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all,

I'm tackling host standby & streaming replication for the first time, in
a small set-up with just two computers (one master, one standby) and an
extremely light load (at its busiest, one transaction every couple of
minutes). Both systems are running PG 9.1 on Debian Wheezy from
apt.postgresql.org.

I've been reading the documentation and the articles on the wiki, and
I'm confused on one point - the official docs [1] and one of the wiki
articles [2] seem to indicate that you need to set up log-shipping as
well as SR, whereas one of the wiki articles [2] indicates that
log-shipping isn't required. I've followed [3] and it seems to work fine
in initial trials; but I'm wondering if I'm missing something, or if I
misunderstood [1] + [2] in the first place.

Clarification would be appreciated!

Many thanks,

Ray.

[1]
http://www.postgresql.org/docs/9.1/static/warm-standby.html#STREAMING-REPLICATION

[2] https://wiki.postgresql.org/wiki/Streaming_Replication

[3]
https://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#Binary_Replication_in_6_Steps

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igor Neyman 2013-09-13 19:54:29 Re: Major upgrade of PostgreSQL and MySQL
Previous Message Patrick Dung 2013-09-13 19:49:37 Re: Major upgrade of PostgreSQL and MySQL