Hello.
I’m trying to connect to a postgreSql database installed on the PC.
User: postgres (password ok)
Base: dbprimustest
dbname=dbprimustest host=localhost port=5432
The service is started but I get this error message:
Thank.
What does the “Plus” button say?
Server side:
service postgresql status
Client side: What is the exact connection string displayed on the status bar of your Base window?
Plus button:
Statut SQL: connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL: password authentication failed for user "postgres"
connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL: password authentication failed for user "postgres"
Code d'erreur: 1
Couldn't establish database connection to 'sdbc:postgresql: host='localhost' port='5432' dbname='dbprimustest''
connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL: password authentication failed for user "postgres"
connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL: password authentication failed for user "postgres"
Base:
service postgresql status
reports if the service is running or not.
● postgresql.service - PostgreSQL RDBMS
Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled; preset: enabled)
Active: active (exited) since Sun 2025-05-25 11:19:56 CEST; 4h 52min ago
Process: 7970 ExecStart=/bin/true (code=exited, status=0/SUCCESS)
Main PID: 7970 (code=exited, status=0/SUCCESS)
CPU: 1ms
mai 25 11:19:56 lpc systemd[1]: Starting postgresql.service - PostgreSQL RDBMS...
mai 25 11:19:56 lpc systemd[1]: Finished postgresql.service - PostgreSQL RDBMS.
Here is what I see when connection to PostgreSQL is established:
Only the post is shown quotation marks.
So this will be shown in database Properties:
Are you able to connect to PostgrsSQL with any other tool through localhost?
Here a hint for PostgreSQL from German Base Handbuch:
Damit der Datenbanknutzer anschließend auch auf die zu gründende Datenbank zugreifen kann, muss in der Datei /var/lib/pgsql/data/pg_hba.conf ein Eintrag geändert werden. In dieser Datei werden u.a. die Methoden zur Identifizierung der Nutzer auf verschiedenen Ebenen festgelegt. Die Methode, mit der LO-Base kommunizieren kann, ist die Methode «password» oder «md5», nicht, wie voreingestellt, die Methode «ident».
Change the method in pg_hdba.conf.
So, I redefined my password (actually, I redefined the same one) and now it’s ok. I don’t know why…
I couldn’t do it with DBeaver either. With the “new” password, it’s ok too.