Attempting to connect

From: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
To: "PostgreSQL" <pgsql-general(at)postgresql(dot)org>
Subject: Attempting to connect
Date: 2009-02-15 21:41:14
Message-ID: 000501c98fb6$20b2ac10$6401a8c0@owner
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2009-02-15 21:44:55 Re: Attempting to connect
Previous Message John R Pierce 2009-02-15 21:03:01 Re: Running untrusted sql safely?