10 months ago
After hitting a billing limit, my deployments where gone. So, I've restored them and now the database can't connect to anything. It's showing this log
2025-08-22 13:36:50.343 UTC [6] LOG: listening on IPv4 address "0.0.0.0", port 5432
2025-08-22 13:36:50.343 UTC [6] LOG: listening on IPv6 address "::", port 5432
2025-08-22 13:36:50.349 UTC [6] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-08-22 13:36:50.359 UTC [29] LOG: database system was interrupted; last known up at 2025-08-22 13:35:13 UTC
2025-08-22 13:36:50.421 UTC [29] LOG: database system was not properly shut down; automatic recovery in progress
2025-08-22 13:36:50.426 UTC [29] LOG: redo starts at 0/1CF4E548
2025-08-22 13:36:50.426 UTC [29] LOG: invalid record length at 0/1CF4E580: expected at least 24, got 0
2025-08-22 13:36:50.426 UTC [29] LOG: redo done at 0/1CF4E548 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2025-08-22 13:36:50.433 UTC [27] LOG: checkpoint starting: end-of-recovery immediate wait
2025-08-22 13:36:50.462 UTC [27] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.008 s, sync=0.005 s, total=0.035 s; sync files=2, longest=0.003 s, average=0.003 s; distance=0 kB, estimate=0 kB; lsn=0/1CF4E580, redo lsn=0/1CF4E580
2025-08-22 13:36:50.470 UTC [6] LOG: database system is ready to accept connectionsProject ID: be3f2db8-13c1-4dfb-b758-fbaace10701c
8 Replies
10 months ago
I'm sorry but I'm not seeing any issues from those logs, can you provide any errors you are seeing?
10 months ago
You don't have a TCP Proxy, that is something the data tab requires.
10 months ago
Note, the database would still be accessible over the private network.
Ok, nevermind. Turns out after the restart the server that connects to the database via private network couldn't connect properly - maybe it started before the database or something, but it worked after a restart
10 months ago
!s
Status changed to Solved brody • 10 months ago
