PostgreSQL Connecting to a Database

Internal

• PostgreSQL Operations

Connect

Connect to a database.

Options

-d|--dbname=

Specifies the name of the database to connect to.

-p

Specifies the port.

Examples

Connect Locally to the Default Database

psql postgres

This should work without any additional configuration.

Connect to a Remote Database

psql -h <host-name> -U <username> -d <database-name>

psql -h dev01.example.us-west-2.rds.amazonaws.com -U root -d dev01

If the database name is not specified, will connect to ...

Connect to the Default Database

psql -h localhost -U admin

Connect as a Specific User to a Database

psql -U <username> <dbname>

Connect to a PostgreSQL Instance Running in a Kubernetes Pod that Has Been Exposed as a NodePort Service

psql -h localhost -p 5432 -U postgres