Re: [Pgpool-general] Cluster pgpool-II + PHP

2010-02-22 Thread Daniel . Crespo
My other question is, the maintenance tasks reindex and vacuum, should be made over pgpool or over each backend? Vaccuum with verbose option should not be used over pgpool. It may cause kind mismatch error because number of messages returned from vacuum may vary on each backend(I have a

Re: [Pgpool-general] Cluster pgpool-II + PHP

2010-02-19 Thread Cesar Martin
Hello there, We do have a cluster with pgpool-II 2.3 and 2 backend Postgres 8.3.9 runing in Centos 5.4 with max_connections=200. This cluster is used by web apllication in PHP 5.2 that connects to DB with pg_pconnect and always with same user. I do have a couple of doubts... I

Re: [Pgpool-general] Cluster pgpool-II + PHP

2010-02-18 Thread Tatsuo Ishii
Hello there, We do have a cluster with pgpool-II 2.3 and 2 backend Postgres 8.3.9 runing in Centos 5.4 with max_connections=200. This cluster is used by web apllication in PHP 5.2 that connects to DB with pg_pconnect and always with same user. I do have a couple of doubts... I assume that