Hi
The postmaster backend seems to be blocked when the identd server of the peer
accepts the connection but does not respond. (ie if the load is too high
on the identd server for example)
In fact, identd is dying without closing the socket. I know that it
is an identd problem ( pident 3.012 )
The identification seems to be performed by the parent process,
not by a child. Postgres stops forking and does not accept
connections anymore. (See strace below)
The timeout seems to be not configurable.
If posgtres is not restarted or if we do not wait for 5 minutes or
more, Postgres keeps blocking.
I hope i am clear enough.
select(6, [3 4 5], [], NULL, NULL) = 1 (in [5])
SYS_175(0x2, 0x8197260, 0, 0x8, 0x2) = 0
read(5, "\0\0\1(", 4) = 4
SYS_175(0x2, 0x81971e0, 0, 0x8, 0x2) = 0
select(6, [3 4 5], [], NULL, NULL) = 1 (in [5])
SYS_175(0x2, 0x8197260, 0, 0x8, 0x2) = 0
read(5, "\0\2\0\0sintes\0\0\0\0\0\0\0\0\0"..., 292) = 292
open("/home/postgres/pg_hba", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/home/postgres/pg_hba.conf", O_RDONLY) = 6
fstat(6, {st_mode=S_ISVTX|0263, st_size=0, ...}) = 0
mmap(0, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x400150
00
read(6, "#\n# Example PostgreSQL host acc"..., 4096) = 4096
read(6, "USERAUTH are not allowed.\n\n# F"..., 4096) = 2597
close(6) = 0
munmap(0x40015000, 4096) = 0
socket(PF_INET, SOCK_STREAM, IPPROTO_IP) = 6
bind(6, {sin_family=AF_INET, sin_port=htons(0), sin_addr=inet_addr("216.167.107.
199")}, 16) = 0
connect(6, {sin_family=AF_INET, sin_port=htons(113), sin_addr=inet_addr("216.167
.107.198")}, 16) = 0
send(6, "1920,5432\n", 10, 0) = 10
recv(6,
-- Sébastien BLON - Technicien Réseaux - blon@nfrance.com Nfrance Conseil - 4 Rue J.F Kennedy - 31000 -
Toulouse
Phone : +33 5 34 455 502 http://www.nfrance.com Fax : +33 5 34 455 507