"Tom Lane" <tgl@sss.pgh.pa.us> wrote in message
news:16753.1080262892@sss.pgh.pa.us...
> So, what shows up in the postmaster log when this happens? Is there a
> core file, and if so can you get a stack trace from it?
>
> > I can connect to the server using trusted login from pgAdminIII from my
> > windows box, with template0 and template1 displayed as with the older
> > version, and cywin ports on windows boxes.
>
> Yeah? Can you connect locally via TCP? Try
> psql -h localhost template1
> If that works then the problem must be localized to Unix socket access
> ... I have no idea what would cause such a problem though ...
>
No core file because the server doesn't terminate despite the error message.
psql -h localhost template1 works! Was used to mysql where local connection
wasn't tcp socket unless explicitly specified. Still doesn't explain why I
can connect with pgAdminIII from the LAN but not successfully execute
commands.
It must be a socket problem; I found the following post in the postgresql
archives, but no attachment, just his PGP signature, and no new
src/template/sco in the source tree:
a.. From: Larry Rosenman <ler ( at ) lerctr ( dot ) org>
b.. To: pgsql-hackers ( at ) postgresql ( dot ) org
c.. Subject: OpenServer 5.0.7: setsockopt(TCP_NODELAY)?
d.. Date: Thu, 06 Nov 2003 18:56:31 -0600
----------------------------------------------------------------------------
----
I asked my friends at SCO (who are productizing PG) to test
7.4RC1 on OpenServer 5.0.7, and received this back:
A "make check" fails at createdb with errors in the postmaster logfile:
LOG: setsockopt(TCP_NODELAY) failed: Protocol not available
Plus he needed to add:
if test "$GCC" != yes ; then
CC="$CC -b elf"
fi
to src/template/sco for 5.0.7.
I downloaded 7.4 RC1 and successfully compiled it on an OpenServer 5.0.7
system.
I am attaching the only change i had to make. This is the file
src/template/sco.
The GCC compiler on OSR5 no longer accepts the "-b elf" argument.
Anyone of the guru's have ideas?
Thanks,
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler ( at ) lerctr ( dot ) org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749