export PATH=$PATH:/app/postgres/rdbms/17.2/bin
export PGDATA=/app/postgres/data/db01
export PGLOG=/app/postgres/log/db01.log
export PGPORT=5501

alias restart='pg_ctl stop; pg_ctl start --pgdata $PGDATA --log $PGLOG'


initdb -D $PGDATA


# in $PGDATA/postgresql.conf
listen_addresses='*'
port=5501

pg_ctl start --pgdata $PGDATA --log $PGLOG


create role jabba login password 'secret';
create database jabba;
alter database jabba owner to jabba;


https://smallstep.com/hello-mtls/doc/combined/postgresql/psql

SELECT backend_start,ssl,version,datname as "Database name", usename as "User name",client_addr, application_name, backend_type
FROM pg_stat_ssl
JOIN pg_stat_activity
ON pg_stat_ssl.pid = pg_stat_activity.pid
ORDER BY backend_start DESC,ssl;