Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

TCP/IP connection



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



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group