Re: [Pgpool-general] PgPoolAdmin V2 beta 1 - Charset encoding Problem with French translation

2007-12-06 Thread Guillaume Lelarge
Hi, Richard MICHALOWICZ a écrit : > Im trying the PgPoolAdmin V2 beta 1 with success but i have a problem > with charset encoding. Indeed, when i use the french translation, i have > some bad characters in sentences with special characters like « é » > « è » « ê » … > You're right. fr.lang.php w

Re: [Pgpool-general] pgpool-II documentation

2009-04-09 Thread Guillaume Lelarge
Le jeudi 09 avril 2009 à 03:03:08, Tatsuo Ishii a écrit : > [...] > Also I'm going to give a talk at PGCon 2009 in Ottawa. I would like to > talk about how pgpool-II tries to keep the consistency among databases. I'll be there too. That's one of the talk I want to attend. -- Guillaume. http://

Re: [Pgpool-general] backend mismatch

2009-07-16 Thread Guillaume Lelarge
Le jeudi 16 juillet 2009 à 15:48:58, Leonardo Carvalho a écrit : >Unfortunately, PgAdmin always sends this commands , trying to use > ISO date format. >If you discover how to fix that in PgAdmin, tell us! > There's no way to fix that without recompiling. But you can try the patch attached

Re: [Pgpool-general] [pgadmin-hackers] backend mismatch

2009-07-20 Thread Guillaume Lelarge
Le lundi 20 juillet 2009 à 17:50:53, Dave Page a écrit : > On Thu, Jul 16, 2009 at 3:38 PM, Guillaume > > Lelarge wrote: > > Le jeudi 16 juillet 2009 à 15:48:58, Leonardo Carvalho a écrit : > >>Unfortunately, PgAdmin always sends this commands , trying to use > >

Re: [Pgpool-general] [pgadmin-hackers] backend mismatch

2009-07-20 Thread Guillaume Lelarge
Le lundi 20 juillet 2009 à 19:06:50, Dave Page a écrit : > On Mon, Jul 20, 2009 at 5:38 PM, Guillaume > > Lelarge wrote: > > The latter. I don't see a way to catch them all easily. I'll commit this, > > and try to find a way to catch the others. > > Good

Re: [Pgpool-general] [pgadmin-hackers] backend mismatch

2009-07-21 Thread Guillaume Lelarge
Le mardi 21 juillet 2009 à 10:12:37, Dave Page a écrit : > On Mon, Jul 20, 2009 at 10:32 PM, Guillaume > > Lelarge wrote: > > Le lundi 20 juillet 2009 à 19:06:50, Dave Page a écrit : > >> On Mon, Jul 20, 2009 at 5:38 PM, Guillaume > >> > >> Lelarge wrot

Re: [Pgpool-general] [pgpool-general] load balancing for dummies

2009-12-13 Thread Guillaume Lelarge
Le dimanche 13 décembre 2009 à 23:44:06, Jaime Casanova a écrit : > [...] > I'm looking at the load balancing and seems to me like is there a way > to broke the sync of a replication using load balancing if a do > something stupid like: > > """ > create table t1(col1 date); > > create table t_int

Re: [Pgpool-general] Database verification

2010-03-04 Thread Guillaume Lelarge
Le 04/03/2010 13:41, Christophe Philemotte a écrit : >>> There exist some diff tools: >>> - apgdiff http://apgdiff.sourceforge.net/ >>> - pgdiff http://pgdiff.sourceforge.net/ >> >> Those are schema-wise. I think that Arjen means data-wise. > you're rigth, I do not know data-wise diff. In fact, I'v

Re: [Pgpool-general] Multi-statement queries

2010-03-05 Thread Guillaume Lelarge
Le 05/03/2010 09:45, Matthias Tief a écrit : > Hallo, > > we are planning to use pgpool-II as replication solution for our > PostgeSQL application. Currently we evaluate, whether the restriction of > pgpool-II affect our application. In the documentation you say: > "pgpool-II cannot process multi-

Re: [Pgpool-general] My blog regarding PostgreSQL and pgpool-II

2010-06-05 Thread Guillaume Lelarge
Le 05/06/2010 02:42, Tatsuo Ishii a écrit : > [...] > I just want to let you know that I have started my *first* English > blog at: http://pgsqlpgpool.blogspot.com/. > > I will post articles regarding PostgreSQL and pgpool-II. > That's great news. I see that you already posted one article. I'm g

Re: [Pgpool-general] Order of Query Results

2010-07-28 Thread Guillaume Lelarge
Le 28/07/2010 16:50, Sean Brown a écrit : > Does PgPool have an issue with the order of results from a query being > returned in a different order? > > With the ongoing issue of our cluster falling out, we just had one member > fall > out again and again, no error in PostgreSQLs log is recorded

Re: [Pgpool-general] Order of Query Results

2010-07-28 Thread Guillaume Lelarge
Le 28/07/2010 17:16, Sean Brown a écrit : > On Wednesday, July 28, 2010 10:56:27 am you wrote: >> Le 28/07/2010 16:50, Sean Brown a écrit : >>> Does PgPool have an issue with the order of results from a query being >>> returned in a different order? >>> >>> With the ongoing issue of our cluster fal

Re: [Pgpool-general] Setting up connections config for load-balancing

2010-08-13 Thread Guillaume Lelarge
Le 13/08/2010 03:02, Josh Berkus a écrit : > >>> Hmmm. You might want to display a more user-friendly value for the >>> user, though, no? >> >> Good point:-) I'm thinking about to change it for coming 3.0. > > Great! Might I also suggest using getopt-long for the PCP commands? > That's alread

Re: [Pgpool-general] pgpool-II 3.0 and getopt.h missing on SCO 5.0.7

2010-08-20 Thread Guillaume Lelarge
Le 20/08/2010 01:49, Tatsuo Ishii a écrit : >> hi! i tried to compile pgpool-II 3.0 beta1 on SCO 5.0.7 , buti >> can't find getopt.h file , i just have an getopt_.h from gnulib but >> is not enough to compile it. >> >> There is a way to disable long options? >> or >> where can i find a

Re: [Pgpool-general] pgpool-II 3.0 and getopt.h missing on SCO 5.0.7

2010-08-20 Thread Guillaume Lelarge
Le 20/08/2010 15:04, Guillaume Lelarge a écrit : > Le 20/08/2010 01:49, Tatsuo Ishii a écrit : >>> hi! i tried to compile pgpool-II 3.0 beta1 on SCO 5.0.7 , buti >>> can't find getopt.h file , i just have an getopt_.h from gnulib but >>> is not enoug

Re: [Pgpool-general] pgpool-II 3.0 and getopt.h missing on SCO 5.0.7

2010-08-21 Thread Guillaume Lelarge
Le 21/08/2010 09:25, Tatsuo Ishii a écrit : >> Le 20/08/2010 15:04, Guillaume Lelarge a écrit : >>> Le 20/08/2010 01:49, Tatsuo Ishii a écrit : >>>>> hi! i tried to compile pgpool-II 3.0 beta1 on SCO 5.0.7 , buti >>>>> can't find getopt.h

Re: [Pgpool-general] pgpool-II 3.0 and getopt.h missing on SCO 5.0.7

2010-08-21 Thread Guillaume Lelarge
Le 21/08/2010 18:08, Guillaume Lelarge a écrit : > Le 21/08/2010 09:25, Tatsuo Ishii a écrit : >>> Le 20/08/2010 15:04, Guillaume Lelarge a écrit : >>>> Le 20/08/2010 01:49, Tatsuo Ishii a écrit : >>>>>> hi! i tried to compile pgpool-II 3.0 beta1

Re: [Pgpool-general] pgpool-II 3.0 and getopt.h missing on SCO 5.0.7

2010-08-21 Thread Guillaume Lelarge
Le 22/08/2010 00:35, Tatsuo Ishii a écrit : >> Le 21/08/2010 09:25, Tatsuo Ishii a écrit : >>>> Le 20/08/2010 15:04, Guillaume Lelarge a écrit : >>>>> Le 20/08/2010 01:49, Tatsuo Ishii a écrit : >>>>>>> hi! i tried to compile pgpool-II

Re: [Pgpool-general] pgpool-II 3.0 and getopt.h missing on SCO 5.0.7

2010-08-22 Thread Guillaume Lelarge
Le 22/08/2010 08:36, Tatsuo Ishii a écrit : >> Le 22/08/2010 00:35, Tatsuo Ishii a écrit : >>>> Le 21/08/2010 09:25, Tatsuo Ishii a écrit : >>>>>> Le 20/08/2010 15:04, Guillaume Lelarge a écrit : >>>>>>> Le 20/08/2010 01:49, Tatsuo Ishii

Re: [Pgpool-general] pgpool-II 3.0 and getopt.h missing on SCO 5.0.7

2010-08-24 Thread Guillaume Lelarge
>>>>>>> Le 21/08/2010 09:25, Tatsuo Ishii a �crit : >>>>>>> >>>>>>>>> Le 20/08/2010 15:04, Guillaume Lelarge a �crit : >>>>>>>>> >>>>>>>>>> Le 20/08

Re: [Pgpool-general] pgpool-II 3.0 and Postgres 9.0

2010-09-25 Thread Guillaume Lelarge
Le 25/09/2010 22:36, Duncan McQueen a écrit : > I see the new version of pgpool-II includes some support for postgres > 9.0. I just installed the binary for postgres, but configure fails > when trying to find libpq (since postgres is installed in /opt). > Specifically. this fails: > > ./configure

Re: [Pgpool-general] [Pgpool-hackers] First try at rephrasing the documentation

2010-12-17 Thread Guillaume Lelarge
Le 18/12/2010 01:47, Tatsuo Ishii a écrit : > [...] >> I did the work on pgpoolII-3.0.1's doc, by the way. > > In the mean time, I think Jean-Paul Argudo is translating the doc to > French and if my memory is correct, he is trying to fix the English > doc as well. Is it possible for you and Jean t

Re: [Pgpool-general] pgpool log file

2011-01-10 Thread Guillaume Lelarge
Hi, Le 10/01/2011 11:28, Armin Nesiren a écrit : > [...] > I have problem with pgpool.log file. > I have specify 'logdir' in pgpool.conf file > logdir = '/var/log/pgpool' > but, pgpool wont write any log file into it. > > /var/log/pgpool/ have mode 777, so everyone can write into it. > I have try

Re: [Pgpool-general] Why need set 'slony' submode in pgpool.conf

2011-01-12 Thread Guillaume Lelarge
Le 12/01/2011 09:40, Zhidong She a écrit : > Hi Guys, > > I'm just a little confused about master_slave_sub_mode option in > configuration file. > If we build a master/slave db replication and deploy pgpool on top of > them, we need set master_slave_mode to true. It does make sence. > But why does

Re: [Pgpool-general] replication/failover feature in Master/Slave mode

2011-01-12 Thread Guillaume Lelarge
Hi, Le 12/01/2011 15:10, Sandeep Thakkar a écrit : > [...] > I have a primary and a standby server on different boxes and both are running > on > different ports. I would like to use pgpool for Streaming Replication and > Failover. Hence, I selected Master/Slave mode with stream. Now, I have a

Re: [Pgpool-general] Query regarding load balancing

2011-01-14 Thread Guillaume Lelarge
Le 14/01/2011 10:16, Sandeep Thakkar a écrit : > [...] > I'm using PG9.0 and pgpool-3.0.1 and I have setup a master and a standby > servers. Standby server is configured for Hot Standby and Stream replication. > I'm using pgpool in Master/Slave mode with Load balancing mode on. I would > like >

Re: [Pgpool-general] sql to know if connection is using pgpool

2011-01-18 Thread Guillaume Lelarge
Le 18/01/2011 16:16, Gary Fu a écrit : > On 01/17/11 19:45, Tatsuo Ishii wrote: >>> Is there a simple query (not the 'show' command) to tell if my current >>> db connection is using pgpool ? >> No. Why is show pool_status not good? > > It causes error when the connection is not using pgpool. >

Re: [Pgpool-general] sql to know if connection is using pgpool

2011-01-18 Thread Guillaume Lelarge
Le 18/01/2011 22:06, Gary Fu a écrit : > On 01/18/11 15:35, Guillaume Lelarge wrote: >> Le 18/01/2011 16:16, Gary Fu a écrit : >>> On 01/17/11 19:45, Tatsuo Ishii wrote: >>>>> Is there a simple query (not the 'show' command) to tell if my current &g

Re: [Pgpool-general] Setting up PGpool with PostgreSQL 9.0

2011-01-20 Thread Guillaume Lelarge
Le 20/01/2011 23:58, Matthew Bennett a écrit : > I am setting up PGpool with PostgreSQL 9.0 using streaming replication. I want > to use PGpool to load balance between the live database and the hot-standby. > The > two Postgres servers are running on their own machines and PGpool is running > on

Re: [Pgpool-general] replication/failover feature in Master/Slave mode

2011-01-27 Thread Guillaume Lelarge
Le 27/01/2011 09:49, Sandeep Thakkar a écrit : > I was just testing the pgpool with one primary and one standby on the same > box. > Hot Standby, Streaming replication, load balancing, all are working fine. > But, I > see that failover is not happening when I shut down my primary server. When I

Re: [Pgpool-general] replication/failover feature in Master/Slave mode

2011-01-27 Thread Guillaume Lelarge
Le 27/01/2011 13:06, Sandeep Thakkar a écrit : > Here, both the dbservers and pgpool run on the single box. This may not be > the > practical scenario, but I was just testing the features. > Hence, I directly used touch. Is it fine then? > If the user has the right to create such a file, yes. I

Re: [Pgpool-general] stuck with a shmem_exit after the loading of "/usr/local/etc/pool_hba.conf"

2011-02-03 Thread Guillaume Lelarge
Le 03/02/2011 10:02, Bharath Keshav a écrit : > I am getting the following error when I try to run Pgpool. I am trying to > use postgresql 9.0 hot streaming and then load balancing capability of > Pgpool. However, I am stuck with a shmem_exit after the loading > of "/usr/local/etc/pool_hba.conf", a

Re: [Pgpool-general] problem with healthcheck

2011-02-03 Thread Guillaume Lelarge
Le 03/02/2011 16:52, Michal Slocinski a écrit : > Hi! > > I'm pgpool newbie trying to setup cluster of two PostgreSQL servers. > > I configureed pgpool.conf as follows: > > # $Header: /cvsroot/pgpool/pgpool-II/pgpool.conf.sample-replication,v > 1.11 2010/09/01 04:58:47 kitagawa Exp $ > listen_ad

Re: [Pgpool-general] White and blacklist of function

2011-02-07 Thread Guillaume Lelarge
Le 07/02/2011 09:35, Wouter D'Haeseleer a écrit : > Hi All, > > Just an enhancement question. > I have noticed that you need to keep a list of blacklisted functions in case > one of the functions does a write to the db. > > Maybe it's a good idea to tackle this in an automated way. > Since if yo

Re: [Pgpool-general] need help on the pgpool architecture

2011-02-08 Thread Guillaume Lelarge
Le 08/02/2011 13:26, Micka a écrit : > I would like to know if it is preferable to use postgreSQL 9 or Postgresql > 8.3.8 ? > > Postgresql 8.3.8 is described in the tutorial. > 9.0. Why use a two years old release... -- Guillaume http://www.postgresql.fr http://dalibo.com __

Re: [Pgpool-general] pcp authentification doesn't work

2011-02-21 Thread Guillaume Lelarge
Le 21/02/2011 18:36, Micka a écrit : > Hi, > > I'm trying to understand on how to use the pcp command, but it doesn't work > see : > > mickael@PTI2:/var/log/pgpool$ pcp_node_count 10 localhost 9898 postgres > pgpoolAdmin > AuthorizationError > > And > sudo nano /usr/local/etc/pcp.conf > >

Re: [Pgpool-general] Problems configuring pgpool-II 3.0 to failover gracefully and load balance queries

2011-02-21 Thread Guillaume Lelarge
Le 21/02/2011 19:59, Stephen Sugden a écrit : > Hello everybody, > > I am trying to configure pgpool-II to load balance queries and provide > failover for 2 (or more) identical backend servers. The application that > will access pgpool only does SELECT queries. The back end servers are > written t

Re: [Pgpool-general] pcp authentification doesn't work

2011-02-22 Thread Guillaume Lelarge
Le 22/02/2011 09:52, Micka a écrit : > by the way : > > -rwxr-xr-x 1 www-data root 722 2010-11-12 06:45 failover.sh > -rw-r--r-- 1 www-data root 982 2011-02-21 18:31 pcp.conf > -rw-r--r-- 1 root root 858 2011-02-22 09:08 pcp.conf.sample > -rw-r--r-- 1 www-data root 9532 2011-02-22 04:59 pgp

Re: [Pgpool-general] pcp authentification doesn't work

2011-02-22 Thread Guillaume Lelarge
Le 22/02/2011 10:58, Micka a écrit : > Thanks, > > " Depends if you told pgpool where to find it. How did you launch pgPool? " > > pgPool is not launching yet. > > Because i'm following this tutorial : > > http://pgpool.projects.postgresql.org/contrib_docs/simple_sr_setting/index.html > > I sh

Re: [Pgpool-general] [pgPool]

2011-02-23 Thread Guillaume Lelarge
Le 23/02/2011 22:58, Micka a écrit : > I tried to test the pcp command myself : > > mickael@PTI2:/usr/local/bin$ psql -U postgres > psql (9.0.3) > Type "help" for help. > > postgres=# ALTER USER postgres WITH PASSWORD 'toto'; > ALTER ROLE > postgres=# \q > mickael@PTI2:/usr/local/bin$ pcp_recover

Re: [Pgpool-general] [pgPool]

2011-02-24 Thread Guillaume Lelarge
Le 24/02/2011 18:17, Micka a écrit : > Yes it was, Thx ! > > Now the replication functionnality work well ! > > but when the main database server goes down I got : > > 2011-02-24 18:06:42 DEBUG: pid 1313: starting health checking > 2011-02-24 18:06:42 DEBUG: pid 1313: health_check: 0 th DB node

Re: [Pgpool-general] Changing the default location of configuration files while building pgpool-II

2011-03-15 Thread Guillaume Lelarge
Le 15/03/2011 14:08, Sandeep Thakkar a écrit : > I think, the default path should be the relative path from where the binary > exists. So, it should be "../etc/pgpool.conf". Can we do it? We use pgpool-II > 3.0.3 sources. > Why don't you use the -f option to specify your configuration file loca

Re: [Pgpool-general] Is pgpool-II v.2.0.1 compatible with PostgreSQL v9.0.3?

2011-03-17 Thread Guillaume Lelarge
Le 17/03/2011 11:53, Gnanakumar a écrit : > Hi, > > Our production server is running PostgreSQL v8.2.3 and pgpool-II-v2.0.1. > > We're planning to upgrade PostgreSQL to the latest version 9.0.3. My > question is, is it possible/compatible to run pgpool-II v.2.0.1 with > PostgreSQL v9.0.3? > Do

Re: [Pgpool-general] lag threshold in slony

2011-03-20 Thread Guillaume Lelarge
Le 20/03/2011 10:44, Tatsuo Ishii a écrit : >> I'm new to pgpool and to this list. I'm trying to set up a load >> balancing cluster using pgpool-II 3.0 and slony. So far it seems to >> work as expected, except for one key aspect: it seems as it is not >> implemeted the lag check for slony, only for

Re: [Pgpool-general] hash index - does not work from slave.

2011-03-22 Thread Guillaume Lelarge
Le 22/03/2011 15:25, Armin Nesiren a écrit : > I have problem reading from slave node values that is indexed with hash > index. > > Does pgpool replicate hash indexes? Is there any special configuration for > hash index? > If you use pgpool replication system, you should have no issue with hash

Re: [Pgpool-general] hash index - does not work from slave.

2011-03-22 Thread Guillaume Lelarge
Le 22/03/2011 16:59, Armin Nesiren a écrit : > But, what am I doing wrong then. > When I insert something in master node, and after that take select, I see my > record. > > On slave, when using index I can not see exact record, and without using > index, record is there. > I have configured stream

Re: [Pgpool-general] pgpool running on only one box?

2011-03-30 Thread Guillaume Lelarge
Le 31/03/2011 02:03, Sean Tegtmeyer a écrit : > Hi all, >In both master-slave mode and replication mode, pgpool-II is only running > on one box, correct? If you only run pgpool on one box, yes, correct. > Therefore pgpool-II does not provide > a fail-over solution in the case that the box ru

Re: [Pgpool-general] pgpool running on only one box?

2011-03-31 Thread Guillaume Lelarge
Le 31/03/2011 09:40, Micka a écrit : > My idea was, and I didn't test it, it's: > > Server 1Server 2 > postgres 9 A postgres9 B > pgpool A pgpool B > application A application B > > The idea was : > > - pgpool A is active, it's doing a streaming rep

Re: [Pgpool-general] Adding new slave node, need to restart pgpool-II?

2011-04-02 Thread Guillaume Lelarge
Le 01/04/2011 03:45, Sean Tegtmeyer a écrit : > Hi all, > When adding in a new slave node to a running database cluster using > pgpool-II w/Postgres9.0 SR, we would need to add a new *"**backend_hostname" > *to the pgpool.conf, correct? Then would it be necessary to restart > pgpool-II as the

Re: [Pgpool-general] Using pgpool-II with PostgreSQL 8.3 and 9.0 at the same time

2011-04-02 Thread Guillaume Lelarge
Le 01/04/2011 08:06, Karl Lehenbauer a écrit : > Hi, > > We have slony replication running with a 4 node cluster and we have been > using pgpool-II for a long time, to load balance certain queries. > > Now we are preparing to migrate to PostgreSQL 9.0. Currently, one of our > slony slaves is

Re: [Pgpool-general] Trouble with pgpool installation

2011-06-10 Thread Guillaume Lelarge
On Fri, 2011-06-10 at 12:52 -0400, Paul Giblock wrote: > Any help with this? > Before putting pgpool in the middle of this, did you install master and slave as recommended on http://www.postgresql.org/docs/9.0/interactive/warm-standby.html ? -- Guillaume http://blog.guillaume.lelarge.info

Re: [Pgpool-general] PgPool logging

2011-07-05 Thread Guillaume Lelarge
On Tue, 2011-07-05 at 10:53 +0200, Mario Splivalo wrote: > I have set up logdir in pgpool.conf, but no logging ever takes place > there. It seem that the only way pgpool is logging stuff is to stdout > (where I can redirect it to file, pipe it to logger process, etc). > I even set debug to 1 in .

Re: [Pgpool-general] PgPool logging

2011-07-05 Thread Guillaume Lelarge
On Tue, 2011-07-05 at 16:18 +0200, Mario Splivalo wrote: > On 07/05/2011 01:51 PM, Guillaume Lelarge wrote: > > On Tue, 2011-07-05 at 10:53 +0200, Mario Splivalo wrote: > >> I have set up logdir in pgpool.conf, but no logging ever takes place > >> there. It seem that the

Re: [Pgpool-general] We really need a change to the API for calling recovery

2011-07-21 Thread Guillaume Lelarge
On Thu, 2011-07-21 at 13:27 +0900, Tatsuo Ishii wrote: > > Tatsuo, > > > > Currently the recovery routine is called on the current master database, > > and the parameters passed to it do not include the master database IP > > address or hostname. Given that the way to provision a node with 9.1 >

Re: [Pgpool-general] We really need a change to the API for calling recovery

2011-07-21 Thread Guillaume Lelarge
On Thu, 2011-07-21 at 16:29 +0900, Tatsuo Ishii wrote: > > On Thu, 2011-07-21 at 13:27 +0900, Tatsuo Ishii wrote: > >> > Tatsuo, > >> > > >> > Currently the recovery routine is called on the current master database, > >> > and the parameters passed to it do not include the master database IP > >>

Re: [Pgpool-general] Confused about JDBC and load balancing

2011-07-21 Thread Guillaume Lelarge
On Thu, 2011-07-21 at 10:41 +0200, David Hartveld wrote: > Op 21-07-11 08:16, Toshihiro Kitagawa schreef: > > On Wed, 20 Jul 2011 11:58:45 -0400 > > Matt Solnit wrote: > > > >> Hi everyone. I'm trying to understand why load balancing doesn't work > >> with the PostgreSQL JDBC driver, and what (i

Re: [Pgpool-general] We really need a change to the API for calling recovery

2011-07-21 Thread Guillaume Lelarge
On Thu, 2011-07-21 at 18:02 +0900, Tatsuo Ishii wrote: > From: Guillaume Lelarge > Subject: Re: [Pgpool-general] We really need a change to the API for calling > recovery > Date: Thu, 21 Jul 2011 10:07:46 +0200 > Message-ID: <1311235666.2018.11.camel@laptop> > > &g

Re: [Pgpool-general] pgpool limitations

2011-08-04 Thread Guillaume Lelarge
On Sat, 2011-07-30 at 08:38 +0900, Tatsuo Ishii wrote: > > On Thu, Jul 28, 2011 at 10:40 PM, Tatsuo Ishii wrote: > > > >> >> Because newly added node is likely to have out of sync databases. Thus > >> >> bringing it online immediately will allow user to use obsolete > >> >> databases. You should

Re: [Pgpool-general] Can pgpool-II retry failed health checks?

2011-08-04 Thread Guillaume Lelarge
On Fri, 2011-08-05 at 00:17 -0400, Matt Solnit wrote: > On Jul 29, 2011, at 10:37 PM, Matthew Solnit wrote: > > > Hi everyone. I'm using pgpool-II 3.0.4 with PostgreSQL 9.0.2, in streaming > > replication mode. We've had > > a couple of cases where pgpool-II got a network timeout while performi

Re: [Pgpool-general] connections not pooling

2011-08-19 Thread Guillaume Lelarge
On Fri, 2011-08-19 at 11:17 -0400, Johnny Tan wrote: > Thanks Tatsuo. > > I originally started with that (num_init_children=16), but then when > all connections were used, even though they were idle, new connections > would hang forever. Sure, it's normal behaviour for pgPool. The pooling is done

Re: [Pgpool-general] connections not pooling

2011-08-19 Thread Guillaume Lelarge
On Fri, 2011-08-19 at 17:12 -0400, Johnny Tan wrote: > >> I originally started with that (num_init_children=16), but then when > >> all connections were used, even though they were idle, new connections > >> would hang forever. > > > > Sure, it's normal behaviour for pgPool. The pooling is done in

Re: [Pgpool-general] Replicate selected table

2011-09-22 Thread Guillaume Lelarge
On Thu, 2011-09-22 at 16:59 +0200, Micka wrote: > Hello, > > I've two server : A & B. > > In the Server A, I've the table 1 and 3 > In the Server B, I've the table 2 and 4. > > I would like to know if the server A can replicate the table 1 and 3 to the > server B. > And the server B can replicat

Re: [Pgpool-general] Pgpool 3.1 errors

2011-10-04 Thread Guillaume Lelarge
On Tue, 2011-10-04 at 10:39 +0200, Olivier NOEL wrote: > Hi, > > I compiled and installed pgpool 3.1 on Debian Wheezy yesterday. No > compile errors. > > But I have a LOT of errors : > > Oct 4 10:09:48 pgpool01 pgpool: 2011-10-04 10:09:48 ERROR: pid 1198: > Child process 7712 was terminated by

Re: [Pgpool-general] Pgpool 3.1 errors

2011-10-04 Thread Guillaume Lelarge
On Tue, 2011-10-04 at 14:36 +0200, Olivier NOEL wrote: > 2011/10/4 Olivier NOEL : > > 2011/10/4 Olivier NOEL : > > > >>> The conf file you're using is a 3.0 one. I hope you don't use that for > >>> 3.1, as it may not work at all. > >> > >> The conf file is essentially the same, no real differences,

Re: [Pgpool-general] pgPool HA set up

2011-10-05 Thread Guillaume Lelarge
On Wed, 2011-10-05 at 09:38 +0100, Thom Brown wrote: > Hi, > > I want to be able to have a primary/standby PostgreSQL setup with > streaming replication and using pgPool to deal with the load balancing > and auto failover. One question I have is can I have 2 instances of > pgPool pointing to the

Re: [Pgpool-general] pgPool HA set up

2011-10-05 Thread Guillaume Lelarge
On Wed, 2011-10-05 at 10:13 +0100, Thom Brown wrote: > On 5 October 2011 10:05, Guillaume Lelarge wrote: > > On Wed, 2011-10-05 at 09:38 +0100, Thom Brown wrote: > >[...] > >> This seems like it should be a very common setup, so does pgPool have > >> provisi

Re: [Pgpool-general] pgPool HA set up

2011-10-05 Thread Guillaume Lelarge
On Wed, 2011-10-05 at 12:22 +0200, Guillaume Lelarge wrote: > On Wed, 2011-10-05 at 10:13 +0100, Thom Brown wrote: > > On 5 October 2011 10:05, Guillaume Lelarge wrote: > > > On Wed, 2011-10-05 at 09:38 +0100, Thom Brown wrote: > > >[...] > > >> This seem

Re: [Pgpool-general] pgPool HA set up

2011-10-05 Thread Guillaume Lelarge
On Wed, 2011-10-05 at 11:44 +0100, Thom Brown wrote: > On 5 October 2011 11:40, Guillaume Lelarge wrote: > > On Wed, 2011-10-05 at 12:22 +0200, Guillaume Lelarge wrote: > >> On Wed, 2011-10-05 at 10:13 +0100, Thom Brown wrote: > >> > On 5 October 2011 10:05, Gu

Re: [Pgpool-general] slow pgpool-II-3.1

2011-10-06 Thread Guillaume Lelarge
On Thu, 2011-10-06 at 14:36 +0200, Armin Nesiren wrote: > Hi everyone, > > I'm experiencing performance issues with pgpool-3.1 > Problem is that when I connect through pgpool to database, database works > slower than > when I connect directly to master. In this test case, I have disabled node2, >

Re: [Pgpool-general] slow pgpool-II-3.1

2011-10-06 Thread Guillaume Lelarge
On Thu, 2011-10-06 at 14:56 +0200, Armin Nesiren wrote: > On Thu, Oct 6, 2011 at 2:48 PM, Guillaume Lelarge > wrote: > > > On Thu, 2011-10-06 at 14:36 +0200, Armin Nesiren wrote: > > > Hi everyone, > > > > > > I'm experiencing performance issu

Re: [Pgpool-general] slow pgpool-II-3.1

2011-10-06 Thread Guillaume Lelarge
On Thu, 2011-10-06 at 16:28 +0200, Olivier NOEL wrote: > 2011/10/6 Guillaume Lelarge : > > On Thu, 2011-10-06 at 14:56 +0200, Armin Nesiren wrote: > >> On Thu, Oct 6, 2011 at 2:48 PM, Guillaume Lelarge > >> wrote: > >> > >> > On Thu, 2011-10-06

Re: [Pgpool-general] How to configure pgpool for pool conexions..

2011-10-06 Thread Guillaume Lelarge
On Thu, 2011-10-06 at 10:59 -0500, Matias Israel Malpica Escobar wrote: > Hi everyone i´ve been trying to understand and configure pgpool for a pool of > connections (not sure if that is the term), i already follow a manual and > confiigure it like this: > > listen_addresses = '*' > port =

Re: [Pgpool-general] slow pgpool-II-3.1

2011-10-06 Thread Guillaume Lelarge
On Thu, 2011-10-06 at 17:27 +0200, Olivier NOEL wrote: > 2011/10/6 Guillaume Lelarge : > > [...] > > >> And it's not. Ok, there is some overhead, but it's veeery slow. > >> > > > > How did you check that? > > > > You may be righ

Re: [Pgpool-general] How to configure pgpool for pool conexions..

2011-10-06 Thread Guillaume Lelarge
On Thu, 2011-10-06 at 11:13 -0500, Matias Israel Malpica Escobar wrote: > Hi thanks for your answers, what i wanted to say about the connections and > errors from pgpool was that, for what i understand postgres returns an error > if the number of connections are higher than its maximum, and pgpoo

Re: [Pgpool-general] slow pgpool-II-3.1

2011-10-08 Thread Guillaume Lelarge
On Thu, 2011-10-06 at 18:44 +0200, Olivier NOEL wrote: > 2011/10/6 Guillaume Lelarge : > > On Thu, 2011-10-06 at 17:27 +0200, Olivier NOEL wrote: > >> 2011/10/6 Guillaume Lelarge : > >> > >> [...] > >> > >> >> An

Re: [Pgpool-general] pgpool-II 3.0.5 released

2011-11-07 Thread Guillaume Lelarge
ich does not update the node > status when reattaching the node in raw mode(Guillaume Lelarge)" > Don't know about the others, but the one you're referring to is fixed on both releases. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com _

Re: [Pgpool-general] pgpool-II child process is segfaulting

2011-11-09 Thread Guillaume Lelarge
On Wed, 2011-11-09 at 13:40 -0430, Lazaro Rubén García Martinez wrote: > Tatsuo, thank you very much for your answer, but when I execute: > > cvs -d :pserver:anonym...@cvs.pgfoundry.org:/cvsroot/pgpool login > > This error is shown: > > cvs [login aborted]: connect to [cvs.pgfoundry.org]:2401 fa

Re: [Pgpool-general] pgpool-II 3.0.5 released

2011-11-11 Thread Guillaume Lelarge
On Fri, 2011-11-11 at 01:27 -0800, Sandeep Thakkar wrote: > Hi, > > > Why one more release of pgpool-II 3.0 series when we have pgpool-II > 3.1 series released already? We were using pgpool-II 3.0.3 and then > updated to 3.1. Now, you have released 3.0.5. Which one should we use > for production?

Re: [Pgpool-general] Authentication method used for sr_check_password, health_check_password and recovery_password

2011-11-20 Thread Guillaume Lelarge
On Sun, 2011-11-20 at 08:13 +0900, Tatsuo Ishii wrote: > > Thank you very much for the answer. > > Is there a plan for using sr_check_password in the next release of pgpool > > 3.1 series? > > Yes, it's in my plan. Unless supporting sr_check_password is too > invasive... Sorry, but I disagree. E

Re: [Pgpool-general] Authentication method used for sr_check_password, health_check_password and recovery_password

2011-11-20 Thread Guillaume Lelarge
On Sun, 2011-11-20 at 18:31 +0900, Tatsuo Ishii wrote: > > On Sun, 2011-11-20 at 08:13 +0900, Tatsuo Ishii wrote: > >> > Thank you very much for the answer. > >> > Is there a plan for using sr_check_password in the next release of > >> > pgpool 3.1 series? > >> > >> Yes, it's in my plan. Unless s

Re: [Pgpool-general] Authentication method used for sr_check_password, health_check_password and recovery_password

2011-11-20 Thread Guillaume Lelarge
On Sun, 2011-11-20 at 17:24 -0430, Lazaro Rubén García Martinez wrote: > I think this feature is very important, because having trust acces in > pg_hba.conf is not a good idea. I understand that and I agree with you. The problem is not on the feature itself, but on which release it should be del