From: | Thomas Keller <kellert(at)ohsu(dot)edu> |
---|---|
To: | Postgresql PDX_Users <pdxpug(at)postgresql(dot)org> |
Subject: | TCP/IP connection |
Date: | 2008-03-01 21:08:42 |
Message-ID: | EF3216A1-02AC-47E9-8BC6-5F69DCA72E23@ohsu.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pdxpug |
Hi,
Upgraded to 8.3.0 it is up and running. (see below for config)
But apparelntly I don't have my pg_hba.conf file set correctly for
web applications using my database.
This is what I have: (I only want OHSU machines to be able to log on
(137.53.n.n)
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "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 137.53.0.0/16 md5
# IPv6 local connections:
host all all ::1/128 md5
This gives me a "Can't connect ..." error.
What have I messed up?
thanks so much,
Tom
MMI Shared Resource Facility
503-494-2442
kellert at ohsu.edu
catinthehat:~ kellert$ ps -U postgres
PID TT STAT TIME COMMAND
461 ?? Ss 0:28.46 postgres: writer process
462 ?? Ss 0:12.76 postgres: wal writer process
463 ?? Ss 0:15.18 postgres: autovacuum launcher process
464 ?? Ss 0:25.86 postgres: stats collector process
459 p3 S 0:15.47 /usr/local/pgsql/bin/postgres
catinthehat:~ kellert$ pg_config
BINDIR = /usr/local/pgsql/bin
DOCDIR = /usr/local/pgsql/doc
INCLUDEDIR = /usr/local/pgsql/include
PKGINCLUDEDIR = /usr/local/pgsql/include
INCLUDEDIR-SERVER = /usr/local/pgsql/include/server
LIBDIR = /usr/local/pgsql/lib
PKGLIBDIR = /usr/local/pgsql/lib
LOCALEDIR =
MANDIR = /usr/local/pgsql/man
SHAREDIR = /usr/local/pgsql/share
SYSCONFDIR = /usr/local/pgsql/etc
PGXS = /usr/local/pgsql/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--with-includes=/sw/include:/opt/local/include' '--with-
libraries=/sw/lib:/opt/local/lib' '--with-perl' '--with-krb5' '--with-
openssl' '--with-pam' '--with-ldap' '--with-bonjour' '--with-libxml'
CC = gcc -no-cpp-precomp
CPPFLAGS = -I/sw/include/libxml2 -I/sw/include -I/sw/include -I/opt/
local/include
CFLAGS = -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -
Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing
CFLAGS_SL =
LDFLAGS = -L/sw/lib -L/sw/lib -L/sw/lib -L/opt/local/lib
LDFLAGS_SL =
LIBS = -lpgport -lxml2 -lpam -lssl -lcrypto -lkrb5 -lz -lreadline -lm
VERSION = PostgreSQL 8.3.0
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Keller | 2008-03-01 21:46:49 | ignore TCP/IP question |
Previous Message | Thomas Keller | 2008-02-29 22:59:45 | upgrade problem |