PostgreSQL 14 with TimescaleDB

sudo mkdir -p /var/oled/postgresql/14

sudo chmod 777 -R /var/oled/postgresql

podman run --name pg14ts281 -t \
-e PGDATA=/var/lib/postgresql/data/pgdata \
-v /var/oled/postgresql/14:/var/lib/postgresql/data \
-e POSTGRES_PASSWORD="zabbix" \
-e POSTGRES_DB="dummy_db" \
-p 7414:5432 -d timescale/timescaledb:2.8.1-pg14

Enter container mode:

podman exec -it pg14ts281 su - postgres

create user 'zabbix':

createuser --pwprompt zabbix

change password for user 'postgres':

# authorize 'psql' utility
psql

# reset password for user 'postgres'
\password postgres
# Enter new password:
# Enter it again:

# exit 'psql' utility
\q