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
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? |