Connect to postrgres with psql password Authentication

Written by James McDonald

IT Tips

0 Comments(s)

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:

mydb=# SELECT VERSION();
# 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)

0 Comments

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…

Meraki Open Source Licenses

Dec 2, 2023

Until today I assumed that Meraki was built in-house with only closed source software. But having a look at the...

VEEAM FAILS

Nov 29, 2023

If you have Veeam backup failing with the Updating BCD failed with Cannot update SafeBoot flag and SentinelOne is...