LibreOffice Base Connect to postgresql

From: Mike <1100100(at)gmail(dot)com>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: LibreOffice Base Connect to postgresql
Date: 2017-12-27 18:53:01
Message-ID: CAECVvTWmef_PGnZv4H8d3L+6wgCfW-3gLM4Kx-8Ki9G_JX4CLA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

I have a very simple database.
It resides on my notebook computer running Fedora 27.
postgres --version
postgres (PostgreSQL) 9.6.6

The name of the database is "joe" and it owned by user "joe."

I open libreoffice base and use the database wizard.
I choose Connect To An Existing Database and from the drop-down menu
choose "PostgresSQL" and click NEXT.
Then, under Connection Settings, I type in -
postgresql://localhost:5432/home/joe and click NEXT.
Then I provide the user authentication - User Name: joe

I then click FINISH and always receive error ---

The connection to the data source "New Database" could not be established.
Couldn't establish database connection to
'sdbc:postgresql:postgresql://localhost:5432/home/joe
FATAL: Ident authentication failed for user "joe"

However, joe is a configured user and owner of database "joe."
I'm simply stuck and can't figure out the cause of the failed authentication.
Is there a better/simpler/easier app I can use or try to connect to,
and manage this postgres database.
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.
Got to be a better way.

Thank you for reading.

Mike

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Carnes, Richard 2017-12-27 20:16:41 RE: LibreOffice Base Connect to postgresql
Previous Message john snow 2017-12-27 11:14:04 postgresql 10's numeric data type maps to xxx in c# golang rust drivers??