Suddenly no longer able to connect to PostgreSQL database

Questions / Help
, ,
1

For the first time, my connection no longer works to my PostgreSQL database. I haven’t made any changes—seems random.

This started happening at 2024-02-16T23:06:53.674Z. Both the application and database are hosted in LHR.

I have restarted it via fly pg restart to no avail. Only error present:

Error: getaddrinfo ENOTFOUND top2.nearest.of.postgresql-database.internal
    at __node_internal_captureLargerStackTrace (node:internal/errors:563:5)
    at __node_internal_ (node:internal/errors:782:10)
    at GetAddrInfoReqWrap.onlookupall [as oncomplete] (node:dns:118:26)

Any pointers?

2

Added postgres

3

I have moved my database from LHR to IAD. Everything is fine now.

4

Jiralite, can you point me to any docs that helped you to move you DB? I can’t seem to find it. Thanks.

5

Possibly related to DNS outage? Postgres "could not translate host name" which has been fixed now.

6

For my database, I recreated it in a new region (there were other reasons alongside this one—it was just a catalyst for things I put off). Maybe how to change the postgres leader region? - #2 by kurt is what you’re looking for, though.

7

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.