public inbox for [email protected]
help / color / mirror / Atom feedFrom: Dave Cramer <[email protected]>
To: Steven Adams <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: ODBC configuration problem
Date: Mon, 18 Nov 2024 17:33:19 -0500
Message-ID: <CADK3HH+-MwXjZCm3wrJwP_q9auD=mNXRiwonZvf7O8ZMz-h-Og@mail.gmail.com> (raw)
In-Reply-To: <CYYPR11MB8306FC280BF8B21A209F9B55DE272@CYYPR11MB8306.namprd11.prod.outlook.com>
References: <CYYPR11MB8306FC280BF8B21A209F9B55DE272@CYYPR11MB8306.namprd11.prod.outlook.com>
I'd prefer if this were on github
https://github.com/postgresql-interfaces/psqlodbc/issues
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 <[email protected]>
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:
> 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], [email protected]
Subject: Re: ODBC configuration problem
In-Reply-To: <CADK3HH+-MwXjZCm3wrJwP_q9auD=mNXRiwonZvf7O8ZMz-h-Og@mail.gmail.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