[pgsql-jp: 37433] DB Connect(PQconnectdb)失敗
村山
Murayama.Minoru @ zc.MitsubishiElectric.co.jp
2006年 8月 20日 (日) 18:07:14 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
$B!!(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 =>
/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
pgsql-jp メーリングリストの案内