Unable to update our postgres data source

💬 Queries and Resources
1
  1. My goal: update the Postgres connection so queries start executing against the right DB.
  2. Issue: I have updated our Postgres connection detail to use the new host ip, however my query that uses this Postgres resource is still sent to old host ip.
  3. Steps I've taken to troubleshoot:
    1. Verified data shows up correctly in new Postgres DB via another 3rd party query tool
    2. Verified IP address is correct
    3. Verified resource is indeed updated with the new ip address
    4. Verified the IP address update happened in the right environment. This resource has two environments.
  4. Additional info: (Cloud or Self-hosted, Screenshots)
    1. image
      image1030×183 20.8 KB
    2. Descript Production (Read-only) has the correct IP address in staging environment
    3. imageI’m testing this query on staging environment.
4

Hi @You_Wu,

Thanks for reaching out! Apologies this topic hasn't gotten traction yet.

I see that you submitted a breakage form as well. I will keep an eye on that since it looks like my teammate asked you for some follow up information

You mentioned that you are testing this with staging, does that mean production is working?

5

Hi Tess,

Thanks for following up. My teammate was able to recreate the staging env and I was able to update it accordingly so this is resolved now. It was weird that I couldn’t save the changes without recreating.

6

Huh, yeah that isn't expected :thinking:, but I'm glad it's working now!