Re: Attempting to connect

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

In response to

Responses

Browse pgsql-general by date

  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