Multiple clean installs: get same error of "invalid length of startup packet"

[Jon Mountjoy]

Hi All,

I've installed new version of cygwin twice now, on two different
machines. I am using the latest build. On the one, I simply did
"Install from Internet", on the other "Download from Internet" and then
later install. So both have a fresh cygwin, and a fresh postgres.

After installing postgres, I fail to connect to it, and get error
messages on the server. For example, if I run it (from the command
line) with the "-i" argument, and try to connect with "psql template1"
then I get:

LOG: invalid length of startup packet
DEBUG: proc_exit(0)
DEBUG: shmem_exit(0)
DEBUG: exit(0)
DEBUG: reaping dead processes
DEBUG: child process (PID 1948) exited with exit code 0

(Here, I have run postmaster with the debug level set to 5).

The client simply says:
psql: server closed the connection unexpectedly. This probably means
the server terminated abnormally before or while processing the
request.

I get the same if I run postmaster without the -i.

If I run postmaster with -i, and then try to connect using: psql -h
localhost template1 then I get the same error on the server, but the
client instead says "psql:could not receive server response to SSL
negotiation packet: Connection reset by peer"./

Any pointers? The fact that this happens on two different machines is
odd. When I use an OLD cygwin installation that I have lying around,
it works fine...

I've included output of cygcheck -c below. Running on windows 2000.

TIA,
Jon


$ cygcheck -c
Cygwin Package Information
Package Version Stat
_update-info-dir 00227-1 OK
ash 20040127-1 OK
base-files 2.6-1 OK
base-passwd 1.1-1 OK
bash 2.05b-16 OK
bzip2 1.0.2-5 OK
clear 1.0-1 OK
crypt 1.1-1 OK
cygipc 2.03-2 OK
cygrunsrv 0.98-3 OK
cygutils 1.2.5-1 OK
cygwin 1.5.9-1 OK
cygwin-doc 1.3-7 OK
diffutils 2.8.4-1 OK
editrights 1.01-1 OK
fileutils 4.1-2 OK
findutils 4.1.7-4 OK
gawk 3.1.3-4 OK
gdbm 1.8.3-7 OK
grep 2.5-1 OK
groff 1.18.1-2 OK
gzip 1.3.5-1 OK
inetutils 1.3.2-26 OK
initscripts 0.9-1 OK
less 381-1 OK
libbz2_1 1.0.2-5 OK
libgdbm 1.8.0-5 OK
libgdbm-devel 1.8.3-7 OK
libgdbm3 1.8.3-3 OK
libgdbm4 1.8.3-7 OK
libgettextpo0 0.12.1-3 OK
libiconv2 1.9.1-3 OK
libintl1 0.10.40-1 OK
libintl2 0.12.1-3 OK
libncurses5 5.2-1 OK
libncurses6 5.2-8 OK
libncurses7 5.3-4 OK
libpcre 4.1-1 OK
libpcre0 4.5-1 OK
libpopt0 1.6.4-4 OK
libreadline4 4.1-2 OK
libreadline5 4.3-5 OK
login 1.9-7 OK
man 1.5k-3 OK
minires 0.97-1 OK
mktemp 1.5-3 OK
ncurses 5.3-4 OK
openssh 3.8p1-1 OK
openssl 0.9.7d-1 OK
postgresql 7.4.1-3 OK
readline 4.3-5 OK
sed 4.0.9-2 OK
sh-utils 2.0.15-4 OK
sysvinit 2.84-4 OK
tar 1.13.25-5 OK
termcap 20021106-2 OK
terminfo 5.3_20030726-1 OK
texinfo 4.2-4 OK
textutils 2.0.21-1 OK
which 1.5-2 OK
zlib 1.2.1-1 OKàš€

[Jon Mountjoy]

Hi All,

Problem solved, though I don't know exactly what caused it.
I upgraded the operating system from SP3 to SP4, uninstalled all
superfluous software (although nothing I uninstalled seemed relevant),
reinstalled from scratch, and now it works. So there was some hidden
dodgy interaction between postgres on cygwin, and the operating system,
which caused postgres to give me invalid length messages.

Regards,
Jon


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)