public inbox for [email protected]  

help / color / mirror / Atom feed

ODBC configuration problem
3+ messages / 2 participants
[nested] [flat]

* ODBC configuration problem
@ 2024-11-18 22:27 Steven Adams <[email protected]>
  2024-11-18 22:33 ` Re: ODBC configuration problem Dave Cramer <[email protected]>
  2024-11-19 02:06 ` Re: ODBC configuration problem Steven Adams <[email protected]>
  0 siblings, 2 replies; 3+ messages in thread

From: Steven Adams @ 2024-11-18 22:27 UTC (permalink / raw)
  To: [email protected] <[email protected]>

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: ODBC configuration problem
  2024-11-18 22:27 ODBC configuration problem Steven Adams <[email protected]>
@ 2024-11-18 22:33 ` Dave Cramer <[email protected]>
  1 sibling, 0 replies; 3+ messages in thread

From: Dave Cramer @ 2024-11-18 22:33 UTC (permalink / raw)
  To: Steven Adams <[email protected]>; +Cc: [email protected] <[email protected]>

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
>
>


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: ODBC configuration problem
  2024-11-18 22:27 ODBC configuration problem Steven Adams <[email protected]>
@ 2024-11-19 02:06 ` Steven Adams <[email protected]>
  1 sibling, 0 replies; 3+ messages in thread

From: Steven Adams @ 2024-11-19 02:06 UTC (permalink / raw)
  To: [email protected] <[email protected]>

Okay, I posted about it on Github.
________________________________
From: Steven Adams <[email protected]>
Sent: Monday, November 18, 2024 4:27 PM
To: [email protected] <[email protected]>
Subject: ODBC configuration problem

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2024-11-19 02:06 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-11-18 22:27 ODBC configuration problem Steven Adams <[email protected]>
2024-11-18 22:33 ` Dave Cramer <[email protected]>
2024-11-19 02:06 ` Steven Adams <[email protected]>

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