Re: Attempting to connect

On Sunday 15 February 2009 2:19:13 pm Adrian Klaver wrote:
> On Sunday 15 February 2009 1:41:14 pm Bob Pawley wrote:
> > Hi
> >
> > I do need some help here.
> >
> > I am still having trouble making a remote connection. The 'Server doesn't
> > listen' message comes up.
> >
> > The config files have been changed as shown below.
> >
> > Postgresql.conf
> >
> > #listen_addresses = '*'
> >
> > pg_hba
> >
> > # TYPE DATABASE USER CIDR-ADDRESs IP-Mask METHOD
> >
> > # IPv4 local connections:
> > host all all 0.0.0.0
> > 255.255.255.255 md5
> > host all all 127.0.0.1/32
> > md5
> > # IPv6 local connections:
> > host all all ::1/128
> > md5
> >
> > I disconnect the firewall during the connection attempt.
> >
> > After changes to the above file I run - pg_ctl reload - and stop/start
> > the server.
> >
> > The last few log entries follows.
> >
> > 2009-02-15 13:01:54 PST LOG: loaded library
> > "$libdir/plugins/plugin_debugger.dll"
> > 2009-02-15 13:02:10 PST LOG: loaded library
> > "$libdir/plugins/plugin_debugger.dll"
> > 2009-02-15 13:10:39 PST LOG: loaded library
> > "$libdir/plugins/plugin_debugger.dll"
> > 2009-02-15 13:16:16 PST LOG: received SIGHUP, reloading configuration
> > files 2009-02-15 13:16:52 PST LOG: loaded library
> > "$libdir/plugins/plugin_debugger.dll"
> >
> > The latest couple of attempts didn't leave a log behind.
> >
> > Thanks
> >
> > Bob
>
> The server is running? Can you connect locally? I don't know how you have
> logging setup, but when I stop/start a server it generates a new log file.
> Are you sure you are looking at the most recent log?
>
> --
> Adrian Klaver
> aklaver(at)comcast(dot)net

Just saw this:
host all all 0.0.0.0
255.255.255.255 md5

You should change this to 0.0.0.0/0 and ditch the the netmask.

See examples at bottom of page below for more information-
http://www.postgresql.org/docs/8.3/interactive/auth-pg-hba-conf.html

--
Adrian Klaver
aklaver(at)comcast(dot)net