Persisting Postgres Data

[jaysonng]

I've been moving my data from Mongo to Postgres and testing around.

I found out that with the current default Postgres setup in docker-compose.yml that data won't persist when docker-compose down is run.

Is there any reason that isn't an option yet (no commented out lines like other options in the docker-compose file).

I found that adding volumes fixes that.

  db:
    image: netreconlab/hipaa-postgres:latest
    environment:
      POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
      PG_PARSE_USER: ${PG_PARSE_USER}
      PG_PARSE_PASSWORD: ${PG_PARSE_PASSWORD}
      PG_PARSE_DB: ${PG_PARSE_DB}
      PMM_USER: ${PMM_USER}
      PMM_PASSWORD: ${PMM_PASSWORD}
    restart: always
    ports:
      - 127.0.0.1:${DB_PORT}:${DB_PORT}
    volumes:
      - pgdata:/var/lib/postgresql/data

volumes:
  pgdata:

If there's a better setup for it pls do let me know.

[cbaker6]

This question is related to docker as opposed to parse-server-swift. The docker-compose example in this repo is intended to be a toy example, you will need to customize to your needs for a real deployment. You are asking about volume mounting, see my comments https://github.com/netreconlab/parse-hipaa/blob/ea87809cfc5d74a574d1729d14a336f36718cbcd/docker-compose.yml#L45-L60

Typically if you are using a hosting service like Heroku, you should use https://www.heroku.com/postgres for your DB. People who volume mount are typically using local setups or customized cloud setup where they customize their own high availability and redundancy

[cbaker6]

An example of how to deploy a parse server on Heroku using docker and Postgres (excludes parse-server-swift) can be found here: https://github.com/netreconlab/parse-hipaa/tree/snapcat#heroku

[jaysonng]

You are asking about volume mounting, see my comments https://github.com/netreconlab/parse-hipaa/blob/ea87809cfc5d74a574d1729d14a336f36718cbcd/docker-compose.yml#L45-L60

Ah there it is. Maybe we can copy over the comment here to the Parse-Server-Swift Docker-compose.yml file?

[cbaker6]

Feel free to open a PR with your suggestions.

[jaysonng]

It will definitely help less informed devs like me about docker and volumes. Will do.