Search Postgresql Archives

Hot standby & SR - log shipping required?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxx


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux