[pgpool-general: 1637] Problem with 'replicate_select'
Gary Fu
gfu at sigmaspace.com
Fri Apr 19 05:19:04 JST 2013
Hi,
I'm running pgpool 3.2.3 with postgresql db server 9.2.4.
In the /SD3dev1/pgpool/pgpool.conf configure file, I have the following
setups:
replication_mode = on
replicate_select = off
load_balance_mode = off
log_per_node_statement = on
From the documentation, the select sql should only send to the master
db, but the test below, I can see it still sends to both dbs. Do I miss
anything here ?
Thanks,
Gary
--------------------------------------------------------------------
psql with select sql
7:47pm 334 gfu at sd3dev1:~$ psql -h sd3dev1
psql (9.2.4)
Type "help" for help.
[sd3dev1.dev1_admin].sd3dev1> select * from config where
name='ControllerUser';
name | value
----------------+---------
ControllerUser | sd3dev1
(1 row)
------------------------------------------------------------------------- pgpool
and log
7:47pm 1024 sd3dev1 at sd3dev1:~$ pgpool -f /SD3dev1/pgpool/pgpool.conf -D -n
2013-04-18 19:47:50 LOG: pid 14202: Backend status file
/SD3dev1/pgpool/log/pgpool_status discarded
2013-04-18 19:47:50 LOG: pid 14202: pgpool-II successfully started.
version 3.2.3 (namameboshi)
2013-04-18 19:47:55 LOG: pid 14262: connection received:
host=172.28.20.137 port=50432
2013-04-18 19:48:04 LOG: pid 14262: DB node id: 0 backend pid: 6692
statement: BEGIN
2013-04-18 19:48:04 LOG: pid 14262: DB node id: 1 backend pid: 6660
statement: BEGIN
2013-04-18 19:48:04 LOG: pid 14262: DB node id: 0 backend pid: 6692
statement: DECLARE _psql_cursor NO SCROLL CURSOR FOR
select * from config where name='ControllerUser';
2013-04-18 19:48:04 LOG: pid 14262: DB node id: 1 backend pid: 6660
statement: DECLARE _psql_cursor NO SCROLL CURSOR FOR
select * from config where name='ControllerUser';
2013-04-18 19:48:04 LOG: pid 14262: DB node id: 0 backend pid: 6692
statement: FETCH FORWARD 1000 FROM _psql_cursor
2013-04-18 19:48:04 LOG: pid 14262: DB node id: 1 backend pid: 6660
statement: FETCH FORWARD 1000 FROM _psql_cursor
2013-04-18 19:48:04 LOG: pid 14262: DB node id: 0 backend pid: 6692
statement: CLOSE _psql_cursor
2013-04-18 19:48:04 LOG: pid 14262: DB node id: 1 backend pid: 6660
statement: CLOSE _psql_cursor
2013-04-18 19:48:04 LOG: pid 14262: DB node id: 1 backend pid: 6660
statement: COMMIT
2013-04-18 19:48:04 LOG: pid 14262: DB node id: 0 backend pid: 6692
statement: COMMIT
More information about the pgpool-general
mailing list