Thread: Pgpool 2

Pgpool 2

From
ALEXANDER JOSE
Date:
Hi, Good night

Set 2 servers with 2 postgres 9.3.4, and installed the pgpool 2 v3.3., Would like to know if anyone knows how to configure pgpool 2 select a query from the master node must be because you are querys have blocks and have a few updates, and this sending to the standby node (read only) and gives me error.

Alexander
DBA Postgres
Venezuela

Re: Pgpool 2

From
Raghu Ram
Date:
On Tue, Nov 4, 2014 at 9:19 AM, ALEXANDER JOSE <aangelj@hotmail.com> wrote:
Hi, Good night

Set 2 servers with 2 postgres 9.3.4, and installed the pgpool 2 v3.3., Would like to know if anyone knows how to configure pgpool 2 select a query from the master node must be because you are querys have blocks and have a few updates, and this sending to the standby node (read only) and gives me error.

 
Could you please share what kind of error message your receiving while configuring PgPool-II for load-balancing mode.

Thanks & Regards
Raghu Ram