[Pgpool-general] Pgpool help needed.

[Nimesh Satam]

Thanks, Tatsuo.

Yes we are using pgpool-II-2.1 and is configured to work in Master-slave mode.

load_balance_mode = true
master_slave_mode = true

If we are using this config, how would pgpool behave in below scenario.

We insert data through pgpool and then we fire a select command, all
been in the same session. Will pgpool send the Insert to the master db
and all the selects to slave database?

In what case will the queries be balanced in between the two dbs?

Regards,
Nimesh.


On 1/14/09, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
> I assume you are running pgpool-II 2.x not pgpool or pgpool-II 1.x.
> Also I assume pgpool is running in master slave mode (there's no such
> thing "load balancer mode").
>
> If all these assumptions are correct:
>
> 1) pgpool is a "connection based" load balancer.
>
> 2) CREATE TEMP TABLE is only sento to Slony master.
>
> 3) The temp table created on the master server can be accessd as long
>   as you are in the same session in which the temp table has been
>   created.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
>
> > Hi,
> >
> > Can anybody tell if pgpool is a connection based load balancer or a
> > query based load balancer?
> >
> > We are currently using slony for replication.
> >
> > We have a requirement wherein we need to create a temp table for a
> > given session. This table will be created on one of the replication
> > servers. Been a temp table it will not be replicated.
> >
> > My consecutive queries need to  fetch data from this temp table. How
> > will pgpool work in this case and what parameters can be set to make
> > sure that the Select query goes to the same db where the temp table is
> > created?
> >
> > FYI: Pgpool is used in load balancer mode.
> >
> > Regards,
> > Nimesh.
> > _______________________________________________
> > Pgpool-general mailing list
> > Pgpool-general at pgfoundry.org
> > http://pgfoundry.org/mailman/listinfo/pgpool-general
>