How to connect to a Postgres accessible under a pathname via JDBC?

Question

I have a Postgres on a server which is available under https://somethig.my.domain/postgres on port 5432.

I'm trying to connect via DataGrip which uses a JDBC driver. But I cannot figure out the connection string.

Official docs doesn't have an example with a subpath:

jdbc:postgresql:database
jdbc:postgresql:/
jdbc:postgresql://host/database
jdbc:postgresql://host/
jdbc:postgresql://host:port/database
jdbc:postgresql://host:port/

And I cannot find a way for a subpath there.

~~Please note that at least 2 different ORMs for Node.js connect to the Postgres without any issue, so it's definitely possible. The question is how to form JDBC connection string.~~ Nope, I'm just connecting to Docker containers here instead of reverse-proxied Postgres under a subpath. Please ignore.

Per the Postgres JDBC docs you will need to percent encode the \ in the URL. — Adrian Klaver
– Adrian Klaver, Commented 22 hours ago
That is what I get for answering from my cell phone, it should be /. — Adrian Klaver
– Adrian Klaver, Commented 18 hours ago
Just forget the /postgres. There are no "subpaths" in DNS. — Laurenz Albe
– Laurenz Albe, Commented 14 hours ago
@RabbanKeyak the /postgres part of the URL. E.g. if a server is set up as a reverse proxy caddyserver.com/docs/caddyfile/patterns#reverse-proxy. — Kazimir Podolski
– Kazimir Podolski, Commented 6 hours ago

Ariel Monaco · Accepted Answer · 2025-11-30 23:06:00Z

1

The DSN normally takes this shape on PostgreSQL:

postgres://postgres:[email protected]:5432/dummy

So you need to add jdbc: in the front like:

jdbc:postgres://postgres:[email protected]:5432/dummy

answered 22 hours ago

Ariel Monaco

4,1701 gold badge27 silver badges21 bronze badges

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

1 Comment

Kazimir Podolski 6 hours ago

Nope, I get an error: [99999] Unable to parse URL jdbc:postgresql://somethig.my.domain:5432/postgres/mydb

Laurenz Albe · Accepted Answer · 2025-12-01 19:33:05Z

1

In a JDBC URL, the thing after the slash that you call “subpath” is the name of the database. Note that the protocol is not http, but jdbc:postgresql.

So to connect to the database postgres on host somethig.my.domain at the (default) port 5432, you would use the URL

jdbc:postgresql://somethig.my.domain:5432/postgres

Look at the image from the DataGrip documentation:

DataGrip connection information dialog

You can either enter the individual constituents (host, port, database name etc.) or you can override the URL that DataGrip constructs out of that information by entering your own JDBC URL.

answered 2 hours ago

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Collectives™ on Stack Overflow

How to connect to a Postgres accessible under a pathname via JDBC?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related