I am trying to implement the Couch2Pg set up on my local machine. The instance is running on docker on port 80. And it is accessible. Same case is true for the CouchDB.
Below is what my couch2pg.env looks like:
URL for couch - ensure no trailing slash is present and username and password at the start of the URL
COUCHDB_URL=https://medic:password@localhost/medic
COUCH2PG_SLEEP_MINS=60
COUCH2PG_DOC_LIMIT=1000
COUCH2PG_RETRY_COUNT=5
COUCH2PG_CHANGES_LIMIT=100
COUCH2PG_USER=couch2pg
COUCH2PG_USER_PASSWORD=mypassword
for docker this needs to be postgres, for local calls to “node .” this should be localhost
POSTGRES_SERVER_NAME=localhost
POSTGRES_USER_NAME=couch2pg
POSTGRES_PASSWORD=mypassword
POSTGRES_DB_NAME=cht_new
POSTGRES_PORT=5432
POSTGRESQL_URL=postgres://$COUCH2PG_USER:$COUCH2PG_USER_PASSWORD@$POSTGRES_SERVER_NAME:5432/$POSTGRES_DB_NAME
export POSTGRESQL_URL=postgres://couch2pg:mypassword@localhost:5432/cht_new
export COUCHDB_URL=https://medic:password@localhost/medic
export COUCH2PG_DOC_LIMIT=1000
export COUCH2PG_RETRY_COUNT=5
export COUCH2PG_SLEEP_MINS=120
export COUCH2PG_CHANGES_LIMIT=1000
I am using Postgres 15 with the password encryption set to md5.
When I run the . ./couch2pg.env && node .
Is there any configuration I am missing in order to make this work?