 |
Oliver Elphick |
at Sep 24, 2007 at 9:51 pm
|
⇧ | 
| |
On Mon, 2007-09-24 at 16:05 -0400, Sugrue, Sean wrote:
I'm trying to connect to postgres through an odbc connection from my PC.
Does the connection need to be enabled
on the server side when postgres and downloaded and compiled or is it
enabled by default or does it matter.
You need to enable listening on the network in postgresql.conf
(listen_addresses = '*') and you also need to permit access to the
particular remote machine in pg_hba.conf by setting up an appropriate
host connection. After changing those files you need to restart the
server or at least send it a SIGHUP. Any firewall needs to allow
through packets for port 5432 (or whatever else you are using).
--
Oliver Elphick olly@lfix.co.uk
Isle of Wight
http://www.lfix.co.uk/oliverGPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
Do you want to know God?
http://www.lfix.co.uk/knowing_god.html--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
