Message-ID: From: "swadams2 (@swadams2)" To: "postgresql-interfaces/psqlodbc" Date: Tue, 19 Nov 2024 02:05:25 +0000 Subject: [postgresql-interfaces/psqlodbc] issue #73: Strange configuration problem List-Id: X-GitHub-Author-Id: 63381378 X-GitHub-Author-Login: swadams2 X-GitHub-Issue: 73 X-GitHub-Repo: postgresql-interfaces/psqlodbc X-GitHub-State: closed X-GitHub-Type: issue X-GitHub-Url: https://github.com/postgresql-interfaces/psqlodbc/issues/73 Content-Type: text/plain; charset=utf-8 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 Also, the listen_addresses setting in postgresql.conf was set to '*'. Any ideas as to why this is happening would be appreciated.