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@comcast.net