Postgres Pro
Downloads
Home   >   mailing lists

Re: ODBC configuration problem - Mailing list pgsql-odbc

From Dave Cramer
Subject Re: ODBC configuration problem
Date
Msg-id CADK3HH+-MwXjZCm3wrJwP_q9auD=mNXRiwonZvf7O8ZMz-h-Og@mail.gmail.com
Whole thread Raw
In response to ODBC configuration problem  (Steven Adams <stevenadams@spiralxllc.com>)
List pgsql-odbc
Tree view

But my guess is that your postgresql.conf file does not have localhost enabled. https://www.postgresql.org/docs/current/runtime-config-connection.html#GUC-LISTEN-ADDRESSES
Dave Cramer
www.postgres.rocks


On Mon, 18 Nov 2024 at 17:28, Steven Adams <stevenadams@spiralxllc.com> wrote:
Hello,

I'm trying to use MS Access with PostgreSQL and so want to configure an ODBC file for this.  Testing it resulted in a connection timeout, so I looked at this to troubleshoot:
Adding a "tcpip=true" line to postgresql.conf and a line to permit a connection from the computer running Access to pg_hba.conf and then restarting PostgreSQL seemed to go without errors, but when I tried to run the psql command afterward, I got this error:
psql: error: connection to server at "localhost" (127.0.0.1), port 5432 failed: Connection refused
        Is the server running on that host and accepting TCP/IP connections?

The psql command worked again after I undid these changes, so I'm trying to figure out how they caused this error.  The line I added to pg_hba.conf was as follows.
host      spiralxprime     web_app     192.168.0.72     scram-sha-256

Any ideas as to why this is happening would be appreciated.

Regards,

Steven Adams

pgsql-odbc by date:

Previous
From: Steven Adams
Date:
Subject: ODBC configuration problem
Next
From: Steven Adams
Date:
Subject: Re: ODBC configuration problem