Re: Odbc connection

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/oliver
GPG: 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.