PostgreSQL Connecting to a Database: Difference between revisions
Jump to navigation
Jump to search
Line 5: | Line 5: | ||
=Overview= | =Overview= | ||
Assuming that a [[PostgreSQL_Concepts#Instance|PostgreSQL instance]] is online and available, a user must connect to a particular [[PostgreSQL_Concepts#Database|database]] hosted by the instance before performing data operations. | Assuming that a [[PostgreSQL_Concepts#Instance|PostgreSQL instance]] is online and available, a user must connect to a particular [[PostgreSQL_Concepts#Database|database]] hosted by the instance before performing data operations. The user establishes a [[PostgreSQL_Concepts#Session|session]], over a lower-level network or local socket [[PostgreSQL_Concepts#Connection|connection]], but in practice, the term sessions and connections are used interchangeably. | ||
=Connect= | =Connect= |
Revision as of 22:21, 6 October 2023
Internal
Overview
Assuming that a PostgreSQL instance is online and available, a user must connect to a particular database hosted by the instance before performing data operations. The user establishes a session, over a lower-level network or local socket connection, but in practice, the term sessions and connections are used interchangeably.
Connect
Connect to a database.
psql <database-name>
Options
-h|--host=
-U|--username=
-d|--dbname=
Specifies the name of the database to connect to.
-p
Specifies the port.
-c, --command
Run only single command (SQL or internal) and exit.
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