Bizarre. I looked through the recent sslmode patch, and while I foundHi Tom,
some things I didn't like, none of them explain this. Could you perhaps
get a trace of the server-to-client interaction? Either strace'ing psql
or watching the IP traffic with a packet sniffer should do --- but make
sure you get the full contents of each packet sent and received.
the attached file is a tcpdump of a connect attempt.
Regards, Andreas
00:14:21.128861 localhost.32821 > localhost.postgresql: F 2173273900:2173273900(0) ack
2168553850 win 32767 <nop,nop,timestamp 108609 106946> (DF)
4500 0034 0340 4000 4006 3982 7f00 0001
7f00 0001 8035 1538 8189 872c 8141 817a
8011 7fff 0dd5 0000 0101 080a 0001 a841
0001 a1c2
00:14:21.131604 localhost.postgresql > localhost.32821: F 1:1(0) ack 1 win 32767
<nop,nop,timestamp 108609 108609> (DF)
4500 0034 0341 4000 4006 3981 7f00 0001
7f00 0001 1538 8035 8141 817a 8189 872d
8011 7fff 0755 0000 0101 080a 0001 a841
0001 a841
00:14:21.131635 localhost.32821 > localhost.postgresql: . ack 2 win 32767
<nop,nop,timestamp 108609 108609> (DF)
4500 0034 0342 4000 4006 3980 7f00 0001
7f00 0001 8035 1538 8189 872d 8141 817b
8010 7fff 0755 0000 0101 080a 0001 a841
0001 a841
00:14:21.132540 localhost.32822 > localhost.postgresql: S 2177528657:2177528657(0) win
32767 <mss 16396,sackOK,timestamp 108609 0,nop,wscale 0> (DF)
4500 003c 0343 4000 4006 3977 7f00 0001
7f00 0001 8036 1538 81ca 7351 0000 0000
a002 7fff 5ce0 0000 0204 400c 0402 080a
0001 a841 0000 0000 0103 0300
00:14:21.132565 localhost.postgresql > localhost.32822: S 2176273229:2176273229(0) ack
2177528658 win 32767 <mss 16396,sackOK,timestamp 108609 108609,nop,wscale 0> (DF)
4500 003c 0344 4000 4006 3976 7f00 0001
7f00 0001 1538 8036 81b7 4b4d 81ca 7352
a012 7fff e787 0000 0204 400c 0402 080a
0001 a841 0001 a841 0103 0300
00:14:21.132582 localhost.32822 > localhost.postgresql: . ack 1 win 32767
<nop,nop,timestamp 108609 108609> (DF)
4500 0034 0345 4000 4006 397d 7f00 0001
7f00 0001 8036 1538 81ca 7352 81b7 4b4e
8010 7fff 50a5 0000 0101 080a 0001 a841
0001 a841
00:14:21.132638 localhost.32822 > localhost.postgresql: P 1:9(8) ack 1 win 32767
<nop,nop,timestamp 108609 108609> (DF)
4500 003c 0346 4000 4006 3974 7f00 0001
7f00 0001 8036 1538 81ca 7352 81b7 4b4e
8018 7fff 358c 0000 0101 080a 0001 a841
0001 a841 0000 0008 04d2 162f
00:14:21.132647 localhost.postgresql > localhost.32822: . ack 9 win 32767
<nop,nop,timestamp 108609 108609> (DF)
4500 0034 0347 4000 4006 397b 7f00 0001
7f00 0001 1538 8036 81b7 4b4e 81ca 735a
8010 7fff 509d 0000 0101 080a 0001 a841
0001 a841
00:14:21.132833 localhost.filenet-tms > localhost.filenet-tms: udp 24
6000 0000 0020 1140 0000 0000 0000 0000
0000 0000 0000 0001 0000 0000 0000 0000
0000 0000 0000 0001 8000 8000 0020 4aa6
0200 0000 1800 0000 0000 0000 9b05 0000
0000 0000 0000 0000
00:14:21.134264 localhost.postgresql > localhost.32822: P 1:2(1) ack 9 win 32767
<nop,nop,timestamp 108609 108609> (DF)
4500 0035 0348 4000 4006 3979 7f00 0001
7f00 0001 1538 8036 81b7 4b4e 81ca 735a
8018 7fff 0294 0000 0101 080a 0001 a841
0001 a841 4e
00:14:21.134284 localhost.32822 > localhost.postgresql: . ack 2 win 32767
<nop,nop,timestamp 108609 108609> (DF)
4500 0034 0349 4000 4006 3979 7f00 0001
7f00 0001 8036 1538 81ca 735a 81b7 4b4f
8010 7fff 509c 0000 0101 080a 0001 a841
0001 a841
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
