Needs advice
on
pgAdminpgAdmin
and
PostgreSQLPostgreSQL

Running Postgresql-12 on Windows 10. Using LibreOffice Base as front end. Clients cannot connect to Postgres with Libreoffice Base even though I've changed the configuration files in Postgres to the correct IP Address, and allowing "trusted" connections to all databases. I have updated and running JDBC connections in Base as well. I'm using port 5432, and firewalls off on all computers.

I can connect to the computer hosting the database and pull up other files, but I cannot connect to Postgres for some reason. The error is "Attempt failed" or "Connection Refused".

At a loss, don't know what else to do. I appreciate any help. Not a programmer or IT guy BTW.

READ LESS
2 upvotes·6.9K views
Replies (2)
Recommends
on
PostgreSQL

The 'trust' connection still requires the user name to be valid and is generally not recommended unless it's a local connection.

If the user name does not exist or does not have permission for that specific database the connection will still be refused.

READ MORE
1 upvote·3.3K views
Back-end Developer ·
Recommends
on
PostgreSQL

It's been forever since I tried this, but I believe LibreOffice Base uses ODBC, not JDBC. First, you have to make sure you have the postgresql odbc driver installed. You can find it here: https://odbc.postgresql.org/

READ MORE
2 upvotes·3.3K views
Avatar of Werner Ackermann