[pgsql-jp: 37434] DB Connect(PQconnectdb)失敗

2006年 8月 21日 (月) 09:14:18 JST

$B$*@$OC$K$J$j$^$9!#B<;3$H?=$7$^$9!#(B
$BAaB.$G$9$,!"<ALd$5$;$F2<$5$$!#(B

$B<+:n%W%m%0%i%`$,(B
PQconnectdb()$B$G<:GT$7$^$9!#(B
PQerrorMessage()$B$G=PNO$5$l$k%(%i!<>pJs$O0J2<$G$9!#(B

DB Connect Error could not connect to server:
       Is the server running locally and accepting
       connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

$B%/%i%$%"%s%H%"%W%j%1!<%7%g%s$G>e5-%(%i!<$r=PNO$9$k%?%$%_%s%0$G(B
PostgreSQL$B%5!<%PB&$K$O0J2<$,=PNO$5$l$^$9!#(B
LOG:  incomplete startup packet

$B%5!<%P!"5Z$S<+@=%/%i%$%"%s%H%W%m%0%i%`$OF10l%^%7%s>e(B
$B$GF0$$$F$$$^$9!#!J#O#S$O(BHP-UX$B!!(B11i)

$B860x5fL@$K=u8@$NDx$*4j$$$7$^$9!#(B
$B"((Bpsql$B$OLdBj$J$/F0:n$7$F$*$j$^$9!#(B
$B"(%j%b!<%HC<Kv$h$j#O#D#B#C%I%i%$%P7PM3$N#T#C#P%=%1%C%H7PM3$N%G!<%?%Y!<%9%"%/%;%9$O(B
$B!!LdBj$J$/F0:n$7$F$*$j$^$9!#(B


$B!c4D6-$J$I$K4X$9$k>pJs$r2<5-$7$^$9!#!d(B
$B-!(BOS$B!'(BHP-UX  B.11.11 U 9000/785 2007975588$B!!(B($B"+(Buname -a$B$N=PNO7k2L!K(B
$B!!!J#1#1#i!!(Bversion1$B!!#6#4%S%C%H!K(B

$B-"(Bpg_config$B$N=PNO7k2L(B
BINDIR = /opt/iexpress/postgresql/bin
DOCDIR = /opt/iexpress/postgresql/doc
INCLUDEDIR = /opt/iexpress/postgresql/include
PKGINCLUDEDIR = /opt/iexpress/postgresql/include
INCLUDEDIR-SERVER = /opt/iexpress/postgresql/include/server
LIBDIR = /opt/iexpress/postgresql/lib
PKGLIBDIR = /opt/iexpress/postgresql/lib
LOCALEDIR =
MANDIR = /opt/iexpress/postgresql/man
SHAREDIR = /opt/iexpress/postgresql/share
SYSCONFDIR = /opt/iexpress/postgresql/etc
PGXS = /opt/iexpress/postgresql/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--prefix=/opt/iexpress/postgresql' '--disable-rpath'
 '--enable-integer-datetimes' '--with-openssl' '--with-krb5'
 '-libdir=/opt/iexpress/postgresql/lib' 'CC=gcc'
 'LDFLAGS=-Wl,+nodefaultrpath'
CC = gcc
CPPFLAGS = -D_XOPEN_SOURCE_EXTENDED
CFLAGS
 = -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wendif-labels -fno-strict-aliasing
CFLAGS_SL = -fpic
LDFLAGS = -Wl,+nodefaultrpath -Wl,-z
LDFLAGS_SL =
LIBS
 = -lpgport -lxnet -lc -lssl -lcrypto -lz -lreadline -ltermcap -lPW -lgen -lBSD
-ldld -lnsl -lm -lkrb5 -lk5crypto -lcom_err
VERSION = PostgreSQL 8.1.4

$B-#(BPostgreSQL$B$O!"%R%e!<%l%C%H%Q%C%+!<%I$N%[!<%`%Z!<%8$K$F%P%$%J%j(B
$B!!Ds6!$5$l$F$$$k$b$N$r;HMQ$7$F$$$^$9!#!J(B11i version1$BMQ$r%@%&%s%m!<%I!K(B

 $B-$<+:n%W%m%0%i%`$N(Bldd$B=PNO7k2L(B
       libpq.sl.4 =>   /lib/pa20_64/libpq.sl.4
       libnsl.1 =>     /lib/pa20_64/libnsl.1
       libpthread.1 => /lib/pa20_64/libpthread.1
       libc.2 =>       /lib/pa20_64/libc.2
       libnsl.1 =>     /lib/pa20_64/libnsl.1
       libkrb5.sl =>   /lib/pa20_64/libkrb5.sl
       libk5crypto.sl =>       /lib/pa20_64/libk5crypto.sl
       libcom_err.sl =>        /lib/pa20_64/libcom_err.sl
       libxti.2 =>     /usr/lib/pa20_64/libxti.2
       libdl.1 =>      /usr/lib/pa20_64/libdl.1
       libk5crypto.sl =>       /usr/lib/pa20_64/libk5crypto.sl
       libcom_err.sl =>        /usr/lib/pa20_64/libcom_err.sl
       /opt/graphics/OpenGL/lib/pa20_64/libogltls.sl =>
$B!!!!(B  /opt/graphics/OpenGL/lib/pa20_64/libogltls.sl

$B-%(BPostgreSQL$B%5!<%P%W%m%0%i%`$N(Bldd$B=PNO7k2L(B
$B!!(B$ ldd postgres
       libxnet.2 =>    /lib/pa20_64/libxnet.2
       libc.2 =>       /lib/pa20_64/libc.2
       libxcurses.1 => /lib/pa20_64/libxcurses.1
       libgen.2 =>     /lib/pa20_64/libgen.2
       libdl.1 =>      /lib/pa20_64/libdl.1
       libnsl.1 =>     /lib/pa20_64/libnsl.1
       libm.2 =>       /lib/pa20_64/libm.2
       libkrb5.sl =>   /lib/pa20_64/libkrb5.sl
       libk5crypto.sl =>       /lib/pa20_64/libk5crypto.sl
       libcom_err.sl =>        /lib/pa20_64/libcom_err.sl
       libxti.2 =>     /usr/lib/pa20_64/libxti.2
       libdl.1 =>      /usr/lib/pa20_64/libdl.1
       libdl.1 =>      /usr/lib/pa20_64/libdl.1
       libxti.2 =>     /usr/lib/pa20_64/libxti.2
       libk5crypto.sl =>       /usr/lib/pa20_64/libk5crypto.sl
       libcom_err.sl =>        /usr/lib/pa20_64/libcom_err.sl
       /opt/graphics/OpenGL/lib/pa20_64/libogltls.sl =>
      /opt/graphics/OpenGL/lib/pa20_64/libogltls.sl

 $B-&%=%1%C%H>pJs!!(B(ll -a$B=PNO7k2L!K!!(B/tmp$B$N2<(B
srwxrwxrwx   1 postgres   users            0  8$B7n(B 20$BF|(B  01:58 .s.PGSQL.5432
-rw-------   1 postgres   users           23  8$B7n(B 20$BF|(B  01:58
 .s.PGSQL.5432.lock

 $B-'(Bpg_hba.conf$B ＠ _Dj(B
# "local" is for Unix domain socket connections only
local   all         all                               trust
# IPv4 local connections:
#host    all         all         127.0.0.1/32          trust
host    all         all         10.160.155.0/24          trust
#host    all         all         10.160.155.170/32          trust
# IPv6 local connections:
#host    all         all         ::1/128               trust
#host    all         all         ::1
 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff        trust

 $B-((Bpostgresql.conf$B ＠ _Dj!JNL$,B?$$$N$GH4?h!K(B
listen_addresses = '*'          # what IP address(es) to listen on;
#listen_addresses = 'localhost'         # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost', '*' = all
 $B!!!!!ACfN,!A(B
unix_socket_directory = '/tmp'
unix_socket_permissions = 0777          # octal
 $B!!!!(B
$B0J>e(B