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

2011-01-18 Thread Gary Fu
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. ___ Pgpool-

Re: [Pgpool-general] psql commands cause fail over

2011-01-18 Thread Gary Fu
Yes, do you mean that I have to disable it ? As far as I know, our application may fail over with it disabled. Thanks, Gary Are you enabling replicate_select? -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp Hi, I noticed

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 Gary Fu
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 db connection is using pgpool ? No. Why is show pool_status not good? It causes error when the co

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 > db connection is using pgpool ? No. Wh

[Pgpool-general] Client application loses connection to pgpool during failover

2011-01-18 Thread Vanessa
Hello, I have pgpool-II installed on one VM and I have PostgreSQL 9.0.2 installed on two other VMs. pgpool is managing the two PostgreSQL servers as a cluster. I also have a client application connected to pgpool. I notice when I bring down the primary database and pgpool is in the process of promo

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

2011-01-18 Thread Tatsuo Ishii
> 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. You can always use SAVEPOINT. -- Tatsuo Is

Re: [Pgpool-general] streaming replication on two different servers

2011-01-18 Thread Tatsuo Ishii
> Hello Tatsuo, > > I will try fiddling with this. Currently, my Trigger file is empty and I am > trying to figure out things from there. I assume pgpool installation is > required only on the primary server, please let me know if I am wrong. No, it's not required. pgpoolAdmin and pgpool must be

Re: [Pgpool-general] psql commands cause fail over

2011-01-18 Thread Tatsuo Ishii
> Yes, do you mean that I have to disable it ? Yes, if you want to avoid error when executing \d. > As far as I know, our > application may fail over with it disabled. If you still have an error in spite of disabling replicate_select, please let me know details (pgpool.conf, pgpool-II version)

Re: [Pgpool-general] psql commands cause fail over

2011-01-18 Thread Gary Fu
On 01/18/11 17:34, Tatsuo Ishii wrote: Yes, do you mean that I have to disable it ? Yes, if you want to avoid error when executing \d. As far as I know, our application may fail over with it disabled. If you still have an error in spite of disabling replicate_select, please let me know d

Re: [Pgpool-general] psql commands cause fail over

2011-01-18 Thread Tatsuo Ishii
>> If you still have an error in spite of disabling replicate_select, >> please let me know details (pgpool.conf, pgpool-II version). > > I think the problem is with the function with insert/update sqls in > it, if the replicate_select is off and I use 'select func_xxx()', then > it will only exec

[Pgpool-general] How to replicate function with replicate_select disabled

2011-01-18 Thread Gary Fu
On 01/18/11 18:02, Tatsuo Ishii wrote: If you still have an error in spite of disabling replicate_select, please let me know details (pgpool.conf, pgpool-II version). I think the problem is with the function with insert/update sqls in it, if the replicate_select is off and I use 'select func_xx

[Pgpool-general] follow up on pg_terminate_backend bug

2011-01-18 Thread Lee, Mija
Hi - I am looking at pgpool for connection pooling only. I have been following these threads: http://pgfoundry.org/pipermail/pgpool-general/2010-May/002704.html http://postgresql.1045698.n5.nabble.com/How-to-know-killed-by-pg-termina te-backend-td2017927.html It's not clear to me from the

Re: [Pgpool-general] How to replicate function with replicate_select disabled

2011-01-18 Thread Tatsuo Ishii
> Sorry, now I understand fail over caused by the \d command problem is > due to the replicate_select is set. My question now is how to > replicate a select function (with insert/update) when replicate_select > is disabled. It looks like that we can use 'black_function_list' > mentioned in the ma

[Pgpool-general] Can we launch multiple pgpool instances in one host?

2011-01-18 Thread Zhidong She
Hi All, Can we install mutliple copies of pgpool in different locations in one machine, e.g, /opt/pgpool-0, /opt/pgpool-1, /opt/pgpool-2, ..., and launch all instances simutanously(of course in diffrent ports)? The configuration of each pgpool.conf is different. I'm thinking if we can build a post