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@xxxxxxxxxxx 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@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
