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-
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
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.
>
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
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
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
> 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
> 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
> 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)
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
>> 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
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
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
> 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
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
15 matches
Mail list logo