Unsure you can achieve this without a read only and a read write application set up, I've always had RW application servers separate from RO ones. You could disable the application connection pool completely and let pg-pool do the pooling for you (not sure of performance impact, if any) as the session needs to be terminated after an insert for pg-pool to load balance correctly (see http://www.pgpool.net/mediawiki/index.php/FAQ, 5th one down for more details). - Sumit On 16 May 2012 16:34, Paulo Correia <paulo.correia@xxxxxxxxx> wrote: > Hello Sumit, > > At the given point there are no exceptions since the tests for using > pgPool-II with the application using a master and a slave resulted in all > connections being done on the master and none on the slave. > > As the application as it's own connection pool, eventually all connections > will have a RW operation and as so all these connections will be linked to > the master. > > As so, I cannot benefit from load balancing since all my connections will be > redirected to the master by pgPool-II, even if they are RO. > > Is it possible to have pgPool-II making only load balance with no connection > pool? > > Best regards, > Paulo Correia > > On 15/05/12 09:01, Sumit Raja wrote: >> >> On 14 May 2012 17:28, Paulo Correia<paulo.correia@xxxxxxxxx> wrote: >>> >>> Hello all! >>> Having a Postgres 9.0 with assynchronous streaming replication to a >>> hot-standby slave, both with CentOs 5.6, how can I use both DB instances >>> for >>> query load balancing? >>> I've tried with pgPool-II but the pooling mechanism is disruptive with >>> the >>> existing pool on the application servers. >> >> Is the application RW or read only? What is the disruption being >> caused? Are you seeing specific exceptions? >> >> - Sumit >> > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Raja Consulting Ltd. Incorporated in England and Wales No. 06454814, Registered Office: 4 Calder Court, Shorebury Point, Amy Johnson Way, Blackpool FY4 2RH -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
