Re: Attempting to connect - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Attempting to connect
Date
Msg-id 200902151419.13565.aklaver@comcast.net
Whole thread Raw
In response to Attempting to connect  ("Bob Pawley" <rjpawley@shaw.ca>)
Responses Re: Attempting to connect
List 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@comcast.net

pgsql-general by date:

Previous
From: Stuart McGraw
Date:
Subject: Re: Running untrusted sql safely?
Next
From: Lennin Caro
Date:
Subject: Re: pg_hba reload