public inbox for [email protected]  

help / color / mirror / Atom feed

From: Steven Adams <[email protected]>
To: [email protected] <[email protected]>
Subject: ODBC configuration problem
Date: Mon, 18 Nov 2024 22:27:42 +0000
Message-ID: <CYYPR11MB8306FC280BF8B21A209F9B55DE272@CYYPR11MB8306.namprd11.prod.outlook.com> (raw)

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:
https://odbc.postgresql.org/faq.html#3.3
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

view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: ODBC configuration problem
  In-Reply-To: <CYYPR11MB8306FC280BF8B21A209F9B55DE272@CYYPR11MB8306.namprd11.prod.outlook.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox