I’m working on migrating a decently large Discourse installation from a single instance (3 years going strong!) to managed Digital Ocean databases and separate frontends. Everything is fine for the initial installation once I boot up the new frontends, there’s a fresh, working installation of Discourse.
However, once I go to restore a backup, it always eventually fails while “restoring dump file”
... [2020-11-14 04:56:16] Creating missing functions in the discourse_functions schema... [2020-11-14 04:56:17] Restoring dump file... (this may take a while) [2020-11-14 04:58:27] psql: error: could not connect to server: could not connect to server: Connection timed out ...
I’m pretty confused as to what could be happening here. The connection seems to be fine since Discourse otherwise works, and I don’t see anything in the DB logs or charts that would lead me to believe there’s a problem on that end of things.
Edit: Just noticed something odd in the logs. In my config file the Postgres port is set to
25060, but the logs talking about the timeout mention port
[2020-11-14 18:20:23] Is the server running on host "[host]" ([ip]) and accepting [2020-11-14 18:20:23] TCP/IP connections on port 5432?
Is it possible that the restore process isn’t respecting the configured port for some reason?