> I want to expand it and rely more heavily on it, but cannot do all my select, update, and insert via psql interface - I constantly have to rely on cheat sheets and command history scrolling. > Is there a better/simpler/easier app I can use or try to connect to, and manage this postgres database. > I'm simply stuck and can't figure out the cause of the failed authentication. > However, joe is a configured user and owner of database "joe." > FATAL: Ident authentication failed for user "joe"
> Couldn't establish database connection to 'sdbc:postgresql:postgresql://localhost:5432/home/joe > The connection to the data source "New Database" could not be established. > I then click FINISH and always receive error. > Then I provide the user authentication - User Name: joe > Then, under Connection Settings, I type in - postgresql://localhost:5432/home/joe and click NEXT. > I choose Connect To An Existing Database and from the drop-down menu choose "PostgresSQL" and click NEXT. > I open libreoffice base and use the database wizard. > The name of the database is "joe" and it owned by user "joe." > It resides on my notebook computer running Fedora 27. > I understand my question is not directly related to postgresql but, I'm hoping someone else has used libreoffice base to connect to, and query postgres databases. > Subject: LibreOffice Base Connect to postgresql > Other UIs which I would say work well are Squirrel SQL and SQL Workbench, both of these depend on a JDBC driver also where PG Admin does not. I'm not a fan of pgadmin 4, but with the newer versions of PG, pgadmin 3 is getting less and less compatible since 9.2+. > As for recommending a management app, I would have to say give pgadmin a try. > Connection string format is as follows: You will need a JDBC driver for PG which you can find here: > I believe using LibreOffice Base, it is specifically connecting via JDBC. I like the looks of SQL Workbench and will need to follow up with this too. Grabbing the postgresql-jdbc driver and will give it a try.
0 kommentar(er)
