What is the solution to this?
http://pgfoundry.org/pipermail/pgpool-general/2010-February/002509.html
http://pgfoundry.org/pipermail/pgpool-general/2010-January/002479.html
Tatsuo, yes. pgAdmin3 or any application(in my testing) that keeps a
persistent connection causes the recovery to
Hi,
Finally, I've found two reasons why it didn't work before:
1. after review of the client software, I've found that, sometimes, it
didn't close the connection, and
2. we are not sure that the current value of sequences are flushed in
the logs with the switch_xlog() function.
For 1., the
Hi,
Finally, I've found two reasons why it didn't work before:
1. after review of the client software, I've found that, sometimes, it
didn't close the connection, and
2. we are not sure that the current value of sequences are flushed in
the logs with the switch_xlog() function.
For 1.,
Hello Tatsuo,
Do you have any type of recommendations of how we can proceed in this situation?
Is there some kind of function that forces persistent connections to be closed
or something like this?
Regards,
---
Fernando Marcelo
www.consultorpc.com
ferna...@consultorpc.com
Em 15/01/2010, às
For further investigation I need a test case which is reproducible the
problem. In my understanding, pgAdmin3 will always give us the
problem. Am I correct?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
Hello Tatsuo,
Do you have any type of recommendations of how we can proceed in this
situation?
Hi Jaume Sabater,
Thanks for answering me.
Before to present you my problem, just a question about the 2nd stage
(you'll understand that this question is linked to my problem). Why the
client connections have to be closed during this stage? Couldn't the
recovered node catch up with the
Hello,
I will join this thread ( without being invited :P ) because i am having the
same problem with pgpool.
I have it running for 1 week on a high load environment and I decided to test
online recovery, that always worked on test env, but i get :
ERROR: pid 1199: wait_connection_closed:
On Wed, Jan 13, 2010 at 4:55 PM, Christophe Philemotte
christophe.philemo...@apreco.be wrote:
Before to present you my problem, just a question about the 2nd stage
(you'll understand that this question is linked to my problem). Why the
client connections have to be closed during this stage?