This approach requires podman and podman-compose:
./start.sh
podman ps -a
Postgres is listening to secure connections on tcp port 5432.
openssl s_client -connect 0.0.0.0:5432 -starttls postgres
psql --set=sslmode=require -h 0.0.0.0 -p 5432 -U postgres -d mydb
By default, you can login to pgadmin4 at:
Note: unless you add the Certificate Authority to your host, your browser will get an ssl warning:
https://0.0.0.0:5433/login?next=%2F
Default login credentials which you can change in the compose.yml under the environment
variables list:
-
PGADMIN_SETUP_EMAIL
-
PGADMIN_SETUP_PASSWORD
-
Email Address / Username -
[email protected]
-
Password -
123321
The default password is postgres
, and you can change it in the env/postgres.env file.
./init-db.sh
psql --set=sslmode=require -h 0.0.0.0 -p 5432 -U postgres -d mydb -c "\dt"