Skip to content

Open access from clearly-defined host (staging) to replica db (read-only)

Most probably, one firewall rule needs to be opened to allow this.

12:44 <+olasd> I think it makes sense to open read only access (so, punch a hole in the firewall, and update pg_hba.conf to allow staging hosts to connect as the guest user)

Plan, something along the line of:

  • fw: Open rule to allow access
  • postgres instance: Allow staging host the connection (pg_hba.conf)
  • Update clearly-defined node to integrate the new db access

Migrated from T2932 (view on Phabricator)

Edited by Antoine R. Dumont