Connect to postrgres with psql password Authentication

Written by James McDonald

April 4, 2023

Connect to postgres DB and show the server version (full string and

psql -U myuser-d mydb -h localhost
Password for user myuser:

# output 
PostgreSQL 15.2 (Debian 15.2-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit

mydb=# show server_version;
# output
15.2 (Debian 15.2-1.pgdg110+1)


Submit a Comment

Your email address will not be published. Required fields are marked *

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The reCAPTCHA verification period has expired. Please reload the page.

You May Also Like…