From: | Adrian Klaver <aklaver(at)comcast(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | "Bob Pawley" <rjpawley(at)shaw(dot)ca> |
Subject: | Re: Attempting to connect |
Date: | 2009-02-15 22:19:13 |
Message-ID: | 200902151419.13565.aklaver@comcast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ken Winter | 2009-02-15 22:25:23 | Re: Array in nested query |
Previous Message | Lennin Caro | 2009-02-15 22:18:21 | Re: pg_hba reload |