Environment config

erobinson · May 21, 2019, 11:16am

I'm currently looking at the sample environments to get a feel for what needs to be included / excluded from my standalone installation.

In the /swiss environment postgresql.yml here:

github.com

dimagi/commcare-cloud/blob/master/environments/swiss/postgresql.yml

DEFAULT_POSTGRESQL_HOST: "127.0.0.1"
SEPARATE_FORM_PROCESSING_DBS: False

pgbouncer_override:
  pgbouncer_default_pool: 290
  pgbouncer_max_connections: 400
  pgbouncer_pool_mode: transaction
  pgbouncer_pool_timeout: 1
  pgbouncer_reserve_pool: 5

postgres_override:
  postgresql_version: '14'
  postgresql_max_connections: 300
  postgresql_wal_keep_segments: 0
  postgresql_work_mem: 1MB
  postgresql_hba_entries:
    - contype: host
      databases: replication
      users: hqrepl
      netmask: 0.0.0.0/0

This file has been truncated. show original

I see the following
DEFAULT_POSTGRESQL_HOST: "127.0.0.1"

Is that address relative to the Commcare Cloud machine? i.e. if I have my Commcare Cloud running in a VM on my own laptop and a separate cloud server visible via public IP where i'm deploying the rest of the Commcare stack, do I specify the public facing URL for that setting or the loopback? PostgreSQL itself won't be listening on the public IP of my cloud server - only on the loopback on the cloud server, but it will be hosted on that server.

Thanks!

czue · May 21, 2019, 11:37am

Hey Ed,

That URL is local to the HQ server(s), not the commcare-cloud instance. So, if I'm understanding your setup correctly localhost should be fine.

erobinson · May 21, 2019, 12:58pm

Perfect, thanks Cory!

erobinson · May 23, 2019, 1:58pm

In the same vein, should the server references in inventory.ini be external (relative to the commcare cloud machine) or internal (relative to the CommcareHQ machine) addresses? i.e. in the scenario above should I be using the external server name or can I use 127.0.0.1 if these services are all on the same CommcareHQ machine (not the same machine as my Commcare Cloud installation)?

What about the SITE_HOST setting in the proxy.yml?

Thanks!