How do I add IP addresses to 'pg_hba.conf'?

Posted October 9, 2019 3.7k views

Hello I’m trying to connect an ETL service to a managed Postgres database, but get the following error:

"FATAL: no pg_hba.conf entry for host \"<IP_ADDRESS>\", user \"<DB_USER>\", database \"<DB_NAME>\", SSL off"

How would I add the following to pg_hba.conf:

host replication [stitch_username] [ip_address_1] md5
host replication [stitch_username] [ip_address_2] md5
host replication [stitch_username] [ip_address_3] md5
host replication [stitch_username] [ip_address_4] md5

As far as I understood, when I added the IP addresses to Trusted Sources that they would also be added to pg_hba.conf.

edited by bobbyiliev

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
1 answer

I don’t think that this would be possible because it’s a managed service and this might break the integrity. Have you tried checking this with the DO’s support team?