Hello,
I had a new installed PostgresSQL instance via LAMP on a OpenSuse Tumbleweed machine. After a lot of configuration changes the postgres service is running and I have access in Bash session. I have created a user account and grant some permissions etc… So far so good!
During the next step to use a GUI (pgAdmin) for administration the DB server I lost some of my hair
The installation of pgAdmin has no Problem. I find a new Application within the Development Menu. But this app don’t connect the DB-Server and stops with timeout. The logs says the error is related to an migration failure. Than I had tried to start sudo pgAdmin4 from BASH, it runs but there was no GUI. I start the Web-Gui again http://localhost:5050 and now I see a login form. But all of my logins only the username, username@localhost, username@pcname.local … produce some error messages on the BASH Session. A ‘@’ is required, a second ‘.’ is also required. If I had a valid Mail-Adress with the Postgres User at first I get a failure because the char after the @ is invalid. In the config I set the configuration to Server=false. My actual configuration seems to be a client server version. I need only a desktop version.
P.S. Wich editor you use to edit secure files? Nano has no line numbers in his display.
Thanks i advance for some helpfully comments.