Hello, I have a problem using postgres 7.0.3 in SCO OpenServer Enterprise.
Postgres 7.0.3 is working fine with TCP port 5432.
The problem is that I need to use postgres with SCO OpenServer Host System,
and this system doesn't have TCP/IP.
Postgres is not working with local UDP.
It's giving a strange result on the variable errno in function
connectDBStart, source fe-connect.c, line 868.
When the program executes line 868
if (connect(conn->sock, &conn->raddr.sa, ...
the variable errno is fixed with a strange value of -2147023356
I think maybe is a problem linking libc.a, but I have couldn't resolve the
problem yet.
Your help will be very appreciated. Please answer to c_ruiz@tutopia.com
Transcript of session follows:
------------------------------
$ pg_ctl status
pg_ctl: postmaster is running (pid: 777)
options are:
/usr/local/pgsql/bin/postmaster
-p 5432
-D /u/postgres/data
-B 64
-b /usr/local/pgsql/bin/postgres
-N 32
$ tail -6 pg_hba.conf
# By default, allow anything over UNIX domain sockets and localhost.
host all 127.0.0.0 255.255.255.0 trust
local all trust
host dbsuc00 192.168.16.1 255.255.255.0 trust
host dbsuc00 192.168.16.2 255.255.255.0 trust
host template1 192.168.16.2 255.255.255.0 trust
$ l /tmp/.s.*
prwxrwxrwx 1 postgres group 0 May 7 13:16 /tmp/.s.PGSQL.5432
$ PGDATA=/u/postgres/data
$ export PGDATA
$ psql
psql: connectDBStart() -- connect() failed: Unknown error
Is the postmaster running at 'localhost'
and accepting connections on Unix socket '5432'?
$ gdb /usr/local/pgsql/bin/psql
GNU gdb 5.0
This GDB was configured as "i386-pc-sco3.2v5.0.5"...
(gdb) break fe-connect.c:868
Breakpoint 2 at 0x80065c28: file fe-connect.c, line 868.
(gdb) cont
Continuing.
Breakpoint 2, connectDBStart (conn=0x8085440) at fe-connect.c:868
868 if (connect(conn->sock, &conn->raddr.sa, conn->raddr_len) < 0)
(gdb) print conn->sock
$2 = 7
(gdb) print conn->raddr.sa
$3 = {sa_family = 1, sa_data = "/tmp/.s.PGSQL."}
(gdb) print conn->raddr_len
$4 = 20
(gdb) print conn->raddr.un
$5 = {sun_family = 1,
sun_path = "/tmp/.s.PGSQL.5432", '\000' <repeats 89 times>}
(gdb) print errno
$6 = 0
(gdb) next
871 if (errno == EINPROGRESS || errno == 0)
(gdb) print errno
$7 = -2147023356
(gdb) cont
Continuing.
psql: connectDBStart() -- connect() failed: Unknown error
Is the postmaster running at 'localhost'
and accepting connections on Unix socket '5432'?
Program exited with code 02.
(gdb)
------------------------------
Thanks in advance.
Carlos Antonio Ruiz Gómez
c_ruiz@tutopia.com
http://globalqss.com