search

thegraphnetwork / EpiGraphHub

Software platform to Gather, transmform, harmonize and store epidemiological data for analytical purposes.
https://epigraphhub.org
GNU General Public License v3.0
8 stars 10 forks source link

feat(postgres): create postgres container for production #186

Closed luabida closed 1 year ago

luabida commented 1 year ago

Start working in postgres container for production (with postgis).

image: postgres:15-alpine3.17

luabida commented 1 year ago

@xmnlab I've bind /var/lib/postgresql/data to $PGDATA on container and got: 

2023-05-05 21:51:47.751 GMT [1] LOG:  skipping missing configuration file "/var/lib/postgresql/data/pgdata/postgresql.auto.conf"
2023-05-05 21:51:47.751 GMT [1] FATAL:  data directory "/var/lib/postgresql/data/pgdata" has wrong ownership
2023-05-05 21:51:47.751 GMT [1] HINT:  The server must be started by the user that owns the data directory.

Any idea why it could happen?

luabida commented 1 year ago

Dev postgres container is not running scripts located at the mount /docker-entrypoint-initdb.d/, probably because they don't have execute permission when the volume is binded with compose-dev

fccoelho commented 1 year ago

We should integrate in this PR moving the data directory to the volume in the /mnt, otherwise we risk running out of disk space in the host soon