Can you try like this?
1) configure num_init_children to 1.
2) restart pgpool
3) find pgpool child process pid(hint: ps status is pgpool: wait for
connection request)
4) strace -p the_pid
5) connect to pgpool
strace should show where pgpool tried to find ssl cert file. Make sure that
it is
I have found that sometimes the client connections get disconnected and the new
ones are established. What I do is I get the PIDs using pcp_proc_count before
running pcp_attach_node and then run pcp_proc_count to check if the PIDs
remain same. I found that the behaviour is random. When can this
Thank you very much Tatsuo Ishii.
- Mensaje original -
De: Tatsuo Ishii is...@sraoss.co.jp
Para: joaquin llano joaquin.ll...@cpxextremadura.com
CC: pgpool-general@pgfoundry.org
Enviados: Miércoles, 23 de Noviembre 2011 8:42:06
Asunto: Re: [Pgpool-general] Maintain connections if backend
Tatsuo, thank you very much for your answer, the problem was solved and now I
can connect through SSL:
In the command window i can see that:
psql -U desarrollo -h 10.13.4.201 -p -d postgres
Contraseña para usuario desarrollo:
psql (9.0.5)
conexión SSL (cifrado: AES256-SHA, bits: 256)
Could you show logs after this:
2011-11-23 04:37:25 ERROR: pid 17472: pool_read: read failed (Success)
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
Tatsuo, thank you very much for your answer, the problem was solved and now I
One possibility is client_idle_limit.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
I have found that sometimes the client connections get disconnected and the
new ones are established. What I do is I get the PIDs using
Not wanting to be impatient, but I'm very concerned about this
problem, since its impossible to predict when it will occur. Is there
additional information that I can provide to investigate this further?
thanks
On Tue, Nov 22, 2011 at 10:11 AM, Lonni J Friedman netll...@gmail.com wrote:
This
This is the log:
2011-11-23 06:20:03 LOG: pid 4504: connection received: host=10.13.4.201
port=33254
2011-11-23 06:20:03 DEBUG: pid 4504: Protocol Major: 1234 Minor: 5679 database:
user:
2011-11-23 06:20:03 DEBUG: pid 4504: SSLRequest from client
2011-11-23 06:20:03 DEBUG: pid 4504:
Looks normal. psql first tried with trust auth. Backend requires md5
auth and pool propagated to psql. psql disconnected connection to
pgpool and tried with md5 auth again. This time it was successfull.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:
That's great, thank you very much for your help and time.
Regards.
-Mensaje original-
De: Tatsuo Ishii [mailto:is...@sraoss.co.jp]
Enviado el: miércoles, 23 de noviembre de 2011 11:03
Para: Lazaro Rubén García Martinez
CC: pgpool-general@pgfoundry.org
Asunto: Re: [Pgpool-general] Error
It's definitely pgpool issue with serializing postgres frontend/backend
protocol messages. Tried on environment with actual (non-simulated)
latency. Same work takes 5 times longer with pgpool then without it.
Using pgpool 3.1.
Regards,
Stevo.
On Mon, Nov 21, 2011 at 3:28 PM, Stevo Slavić
Hi,
I have trouble setting up pgpool2-3.0.2 (from Debian Squeeze backports)
with two PostgreSQL 9.1 servers in streaming replication mode. When I
set the {pool,pg}_hba.conf settings to ``trust``, everything seems to go
smoothly. However, in my production environment, I don't want just
anyone do
Hello everyone, I have some questions related with pgpool-HA.
1. Can I use pgpool-HA with pgpool-II 3.1 in streaming replication mode?
2. Is there a repository for installing pgpool-HA in CentOS from yum command?
3. Is there any documentation for configuring an environment with Pgpool-II and
Hello everyone, I have some questions related with pgpool-HA.
1. Can I use pgpool-HA with pgpool-II 3.1 in streaming replication mode?
Yes. Please make sure that start pgpool with -D option.
2. Is there a repository for installing pgpool-HA in CentOS from yum command?
I don't know. I know
On Thu, 2011-11-24 at 09:15 +0900, Tatsuo Ishii wrote:
2. Is there a repository for installing pgpool-HA in CentOS from yum
command?
I don't know. I know Devrim is responsible for creating Redhat rpm for
pgpool, but I'm not sure he has done it for pgpool-HA.
Well, I haven't built -ha
I have trouble setting up pgpool2-3.0.2 (from Debian Squeeze backports)
with two PostgreSQL 9.1 servers in streaming replication mode. When I
set the {pool,pg}_hba.conf settings to ``trust``, everything seems to go
smoothly. However, in my production environment, I don't want just
anyone do
Not wanting to be impatient, but I'm very concerned about this
problem, since its impossible to predict when it will occur. Is there
additional information that I can provide to investigate this further?
I really need to know where pgpool is looping.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
On Wed, Nov 23, 2011 at 10:42 PM, Tatsuo Ishii is...@sraoss.co.jp wrote:
Not wanting to be impatient, but I'm very concerned about this
problem, since its impossible to predict when it will occur. Is there
additional information that I can provide to investigate this further?
I really need
On Wed, Nov 23, 2011 at 10:42 PM, Tatsuo Ishii is...@sraoss.co.jp wrote:
Not wanting to be impatient, but I'm very concerned about this
problem, since its impossible to predict when it will occur. Is there
additional information that I can provide to investigate this further?
I really need
19 matches
Mail list logo