search

PostgresApp / PostgresApp

The easiest way to get started with PostgreSQL on the Mac
https://postgresapp.com
Other
7.32k stars 382 forks source link

failed to verify "trust" authentication #777

Open andriesfc opened 1 week ago

andriesfc commented 1 week ago

I get this every now and then:

Caused by: java.sql.SQLException: Error in allocating a connection. Cause: Connection could not be allocated because: FATAL: Postgres.app failed to verify "trust" authentication
  Hint: You may be able to connect by editing app permission in Postgres.app settings. Please report this error to https://github.com/PostgresApp/PostgresApp/issues
    at com.sun.gjc.spi.base.DataSource.getConnection(DataSource.java:115)
    at oracle.toplink.essentials.jndi.JNDIConnector.connect(JNDIConnector.java:130)
    ... 102 more
jakob commented 1 week ago

Thanks for reporting this!

There should be a bit more info in the server log. Can you copy-paste the full error message from the server log?

Does stopping and starting the PostgreSQL server fix the issue?

larrybolt commented 1 week ago

Thanks for reporting this!

There should be a bit more info in the server log. Can you copy-paste the full error message from the server log?

Does stopping and starting the PostgreSQL server fix the issue?

Restarting the server did solved an issue with same error message for me, thanks! CleanShot 2024-10-24 at 13 57 37@2x

andriesfc commented 1 week ago

The log was not very helpfull.
full. But I will attach the log for part of the 22nd 23'rd (as I mostly leave my laptop on 24x7).

postgres.log.txt

As @jakob suggestion to start/stop the server seems to work, after I deleting the PID file.

Sometimes I do miss linux, as now I have to hunt for the system logs on this mac credit card monster 😀.