[Pgpool-general] Pgpool help needed.

[Tatsuo Ishii]

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