Cannot connect to PgPool
I have 3 postgresql services running and I have them correctly
referenced in the pgpool.conf file.
However, I get the following error when I try to create db's to them
using the following command:
psql -p 9999 db_name
psql: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The PgPool log when this occurs is the following:
2008-01-04 20:37:12 LOG: pid 8670: Cannot accept() new connection.
all backends are down
2008-01-04 20:37:12 DEBUG: pid 8663: reap_handler called
2008-01-04 20:37:12 DEBUG: pid 8663: reap_handler: call wait3
2008-01-04 20:37:12 DEBUG: pid 8663: child 8670 exits with status 256
by signal 0
2008-01-04 20:37:12 DEBUG: pid 8663: fork a new child pid 8881
2008-01-04 20:37:12 DEBUG: pid 8663: reap_handler: normally exited
2008-01-04 20:37:12 DEBUG: pid 8881: I am 8881
Can you provide more info please?
- pgpool version(I assume it's pgpool-II since you use 3 PostgreSQL
servers)
- pgpool.conf
Do you get the error right after start psql? Or it only happens after
you issue create database command?
Also please provide detailed log which can be obtained by using -d
(debug) option?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
Show quoted text
I have 3 postgresql services running and I have them correctly
referenced in the pgpool.conf file.However, I get the following error when I try to create db's to them
using the following command:
psql -p 9999 db_namepsql: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.The PgPool log when this occurs is the following:
2008-01-04 20:37:12 LOG: pid 8670: Cannot accept() new connection.
all backends are down
2008-01-04 20:37:12 DEBUG: pid 8663: reap_handler called
2008-01-04 20:37:12 DEBUG: pid 8663: reap_handler: call wait3
2008-01-04 20:37:12 DEBUG: pid 8663: child 8670 exits with status 256
by signal 0
2008-01-04 20:37:12 DEBUG: pid 8663: fork a new child pid 8881
2008-01-04 20:37:12 DEBUG: pid 8663: reap_handler: normally exited
2008-01-04 20:37:12 DEBUG: pid 8881: I am 8881---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
I had this exact problem. I had to in fact compile the pgpool-II source
code rather than yum install pgpool-II.
On Jan 8, 2008 9:55 AM, Tatsuo Ishii <ishii@postgresql.org> wrote:
Show quoted text
Can you provide more info please?
- pgpool version(I assume it's pgpool-II since you use 3 PostgreSQL
servers)- pgpool.conf
Do you get the error right after start psql? Or it only happens after
you issue create database command?Also please provide detailed log which can be obtained by using -d
(debug) option?
--
Tatsuo Ishii
SRA OSS, Inc. JapanI have 3 postgresql services running and I have them correctly
referenced in the pgpool.conf file.However, I get the following error when I try to create db's to them
using the following command:
psql -p 9999 db_namepsql: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.The PgPool log when this occurs is the following:
2008-01-04 20:37:12 LOG: pid 8670: Cannot accept() new connection.
all backends are down
2008-01-04 20:37:12 DEBUG: pid 8663: reap_handler called
2008-01-04 20:37:12 DEBUG: pid 8663: reap_handler: call wait3
2008-01-04 20:37:12 DEBUG: pid 8663: child 8670 exits with status 256
by signal 0
2008-01-04 20:37:12 DEBUG: pid 8663: fork a new child pid 8881
2008-01-04 20:37:12 DEBUG: pid 8663: reap_handler: normally exited
2008-01-04 20:37:12 DEBUG: pid 8881: I am 8881---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings