[pgpool-general: 346] Sugestion for the streaming repplication multi server guide

Adonias Malosso malosso at gmail.com
Thu Apr 5 04:00:31 JST 2012


Hi all,

I´ve done a few testing in pg 9.1 with pgpool 3.1.2 as describe on
http://www.pgpool.net/pgpool
-web/contrib_docs/simple_sr_setting2_3.1/index.html

Everything worked except that the slave missed some wal segments.

So, i´ve done a few steps more and i´d like to share with you:

In postgresql.conf
wal_keep_segments = 10

10 is just a simple number and needs to be adjusted according to your load

Before starting the slave, and from
http://wiki.postgresql.org/wiki/Streaming_Replication

$ psql -c "SELECT pg_start_backup('label', true)"
$ rsync -a ${PGDATA}/ standby:/srv/pgsql/standby/ --exclude postmaster.pid
$ psql -c "SELECT pg_stop_backup()"


That´s it, worked great for me on debian 6. The only thing is that in
pgpooladmin both,
primary and slave, servers appears on node info as " Running as primary
server"

Regards
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120404/abd4dee7/attachment.html>


More information about the pgpool-general mailing list