Postgres on Elestio with CI/CD

Example CI/CD pipeline showing how to deploy a postgres instance to elestio.

Once deployed ...

You can can open pgAdmin web UI here:

https://[CI_CD_DOMAIN]/
Login: [ADMIN_EMAIL] (set in env var)
password: [ADMIN_PASSWORD] (set in env var)

You can connect to your server with any Postgres client with those credentials:

Host: [CI_CD_DOMAIN]
Port: 25432
Login: postgres
Password: [SOFTWARE_PASSWORD] (set in env var)

You can also connect with any PostgreSQL client, including the official CLI:

PGPASSWORD=[SOFTWARE_PASSWORD] psql --host=[CI_CD_DOMAIN] --port=25432 --username=postgres