Bash command to check JDBC URL in Postgres database

Question

How to check what is your JDBC URL on PostgreSQL database on a Ubuntu 19.04 machine. I mean if there is any command kindly provide me what it is:

I am trying to connect from the official document command:

jdbc:postgresql://localhost:5432/idempiere

but not getting any result.

CarlosRuiz · Accepted Answer · 2020-02-26 11:03:36Z

2

You can check this URI adding the user:

psql -d postgresql://localhost:5432/idempiere?user=adempiere

If you don't add the user at the end it will assume your linux user.

pg_isready just checks if the server localhost is accepting connections on the port 5432 - it doesn't check the database.

Regards,

Carlos Ruiz

answered Feb 26, 2020 at 11:03

CarlosRuiz

3912 silver badges3 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Laurenz Albe · Accepted Answer · 2020-02-25 11:34:04Z

1

If you want the connect string equivalent to the JDBC URI in your question, and you want to test if you can connect to the database, try

pg_isready -d postgresql://localhost:5432/idempiere

answered Feb 25, 2020 at 11:34

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges