TCP/IP connection

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

Browse pdxpug by date

  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