SilvanBaach / GNX_Webapp

MIT License
1 stars 0 forks source link

Dockerize Database #97

Open jaypi95 opened 1 year ago

jaypi95 commented 1 year ago

Is your feature request related to a problem? Please describe. AFAIK currently the db is a plain old postgres installation not in docker. This makes it hard to manage.

Describe the solution you'd like

  1. Export a snapshot of the database
  2. Use an existing postgres docker container --> https://hub.docker.com/_/postgres/
  3. Import the snapshot

That way we can have all the containers in the same network and remove external db access if needed. Also we can push new versions of the database through our pipeline.

Backing up the system would be easier too because you could just automate an sqldump and then back up that plus the docker-compose.yml