30 lines
754 B
Plaintext
30 lines
754 B
Plaintext
|
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;
|