[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
Japanese:http://www.sraoss.co.jp
More information about the pgpool-general
mailing list