cmaksymenko / avalanchecms

Avalanche is a CMS for AI-generated art. Refine, safeguard and publish your works with confidence.
Apache License 2.0
3 stars 1 forks source link

Connect pgAdmin to PostgreSQL database #6

Closed cmaksymenko closed 8 months ago

cmaksymenko commented 9 months ago

Right now pgAdmin uses a local docker volume to store its data. It is possible to use PostgreSQL as a store, see https://www.pgadmin.org/docs/pgadmin4/latest/external_database.html

If we would store the data there, we can better inspect it, and reduces the local stack by one volume.

Similar to the keycloak user, in setup-postgres-db.sh we want to have a seperate pgAdmin db and user, if possible (not sure yet what pgAdmin needs in that regard). If admin user is needed, we can live with that for the Dev environment...

If that works, the superfluous volume doesnt need to be created anymore and should be removed from the stack, obviously.