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.

Sean

Search Discussions

  • 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/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.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedSep 24, '07 at 8:18p
activeSep 24, '07 at 9:51p
posts2
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Oliver Elphick: 1 post Sugrue, Sean: 1 post

People

Translate

site design / logo © 2022 Grokbase