PostgreSQL

• Info

• Config

• pgadmin

• Commands

• user

• db

Info

SELECT version();
SELECT now();

Config

https://www.postgresql.org/docs/current/static/runtime-config-file-locations.html

SHOW config_file;       -- /var/lib/postgresql/data/postgresql.conf
SHOW data_directory;    -- /var/lib/postgresql/data
SHOW hba_file;          -- /var/lib/postgresql/data/pg_hba.conf
    -- host-based authentication
    -- https://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html
SHOW ident_file;        -- /var/lib/postgresql/data/pg_ident.conf
    -- user name mapping: SYSTEM-USERNAME PG-USERNAME
SHOW external_pid_file;

pgadmin

docker run -p 80:80 \
-e "PGADMIN_DEFAULT_EMAIL=[e-mail]" \
-e "PGADMIN_DEFAULT_PASSWORD=SuperSecret" \
-d dpage/pgadmin4

DB->'Schemas'->'public'->'Tables'->right click table->'View/Edit Data'->'All Rows'

Commands

https://www.postgresql.org/docs/current/static/app-psql.html

user

SELECT usename FROM pg_user;
CREATE USER fzinfz;
\password fzinfz
ALTER USER fzinfz WITH SUPERUSER;
\du
    -- list user/role

db

CREATE database tutorial;
\c tutorial
psql -U postgres -h localhost -d tutorial