[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

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

$ 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

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