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

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 (view raw or flat)
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

pdxpug by date

Next:From: Thomas KellerDate: 2008-03-01 21:46:49
Subject: ignore TCP/IP question
Previous:From: Thomas KellerDate: 2008-02-29 22:59:45
Subject: upgrade problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group