postgresql

postgresql service local

https://hub.docker.com/_/postgres

docker run --name postgres -e POSTGRES_PASSWORD=mysecretpassword -d postgres
docker exec -it postgres /bin/bash

test connection

pg_isready -d  -h  -p  -U 
pg_isready -h 127.0.0.1 -p 5432 -U root

apt install postgresql-client-13

find configuration file

psql -U postgres -c 'SHOW config_file'

print time

psql -U postgres -c "select (to_char(CURRENT_TIMESTAMP ,'yyyy-MM-dd HH24:MI')||':00')::timestamp"