[pgpool-general: 5149] Re: Masterless pgpool-II

Tatsuo Ishii ishii at sraoss.co.jp
Wed Dec 7 14:38:25 JST 2016

> Hello!
> After plenty of testing, I'm coming to you because I've been trying to set
> up pgpool-II using only two slaves that are using streaming replication,
> and no master behind the pgpool-II setup.  Is there any optimal (existing)
> way of doing this?  I'm trying to test out an application that could have
> significant load impact without pgpool, so I'm trying to test against a
> pool that won't cause issues with production.

It wouldn't work because Pgpool-II will send write queries to node 0
anyway and you will get something like:

test=# create table t1(i int);
ERROR:  cannot execute CREATE TABLE in a read-only transaction

Best regards,
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php

More information about the pgpool-general mailing list