PostgreSQL Connection URL

JII picture JII · Aug 27, 2010 · Viewed 295.1k times · Source

How is the PostgreSQL connection URL formed, when the host is some other computer than the localhost?

I have allowed PostgreSQL to accept requests from outside.

Answer

Andrey picture Andrey · Dec 21, 2013

If you use Libpq binding for respective language, according to its documentation URI is formed as follows:

postgresql://[user[:password]@][netloc][:port][/dbname][?param1=value1&...]

Here are examples from same document

postgresql://
postgresql://localhost
postgresql://localhost:5432
postgresql://localhost/mydb
postgresql://user@localhost
postgresql://user:secret@localhost
postgresql://other@localhost/otherdb?connect_timeout=10&application_name=myapp
postgresql://localhost/mydb?user=other&password=secret