Running local CHT Sync setup with couch2pg, PostgreSQL, pgAdmin, dbt, and CouchDB

Technical Support
2

oh - update! the next section in the docs “Separate CouchDB instance” seems to work well!

Here’s the steps I took for this:

  1. set up a docker helper instance at https://192-168-68-26.local-ip.medicmobile.org:10445/
  2. edit my .env bottom #coucdb section to be:
    # couchdb
COUCHDB_USER=medic
COUCHDB_PASSWORD=password
COUCHDB_DBS="medic" # space separated list of databases you want to sync e.g "medic medic_sentinel"
COUCHDB_HOST=192-168-68-26.local-ip.medicmobile.org
COUCHDB_PORT=10445
COUCHDB_SECURE=true
  3. ran the docker call: docker compose -f docker-compose.postgres.yml -f docker-compose.yml up
  4. logged into pgadmin (after setting up a new connection to postgres host) and was able to browse all the imported rows in v1 database

So it’s just the all in one with couchdb that has the errors, while using an external couchdb seems to work OK!

3 Likes