Hello There, I’m new on the suse forums. I’m trying to setup the database to use locally for development purpose and I even asked a question on stackoverflow which had no answers… Could someone give-me some hints before I experiment with those and break something? I tried searching the forum but did not find anything related.
I see there are quite some other people using DBeaver with Thumbleweed.
Did you use the GUI to set up the connection?
Before using DBeaver and connecting the PostgreSQL on localhost, you should able to enter the Postgresql shell with
$ psql -U newuser -h localhost first. If not, then useless to use DBeaver to connect to Postgresql.
I have read your Stackoverflow thread, and I see you get the error message when trying to enter Postgresql shell,
psql: error: connection to server at “localhost” (::1), port 5432 failed: FATAL: password authentication failed for user
For my suggestion, If you want to keep your local system clean, it could be better if you want to run Postgresql server service from Docker or Podman.
I have been using this docker strategy to serve several services into my localhost for years, such as Postgresql server and Redis server. So my development tools did not depend on system (distribution) packages.