postgres db service not accessible from my client
This morning, the DB refuses to accept connections and when I checked the logs, I saw this: does this cause DB downtime? any way to debug what is causing my DB instance to be unavailable?
2023-09-11 22:03:57.212 UTC [10992] LOG: the "timescaledb" extension is not up-to-date
2023-09-11 22:03:57.212 UTC [10992] HINT: The most up-to-date version is 2.11.2, the installed version is 2.1.1.
2023-09-12 02:57:22.262 UTC [11873] LOG: invalid length of startup packet
project: 338a4c15-5f76-4fd4-a068-7f68f443c4c4
28 Replies
Project ID:
338a4c15-5f76-4fd4-a068-7f68f443c4c4
but you can access it?
when i go to railway interface, i am able to see the tables. when I try to access it from python code or TablePlus editor, both are throwing timeout error
are you sure you are using the correct credentials?
yes, till yesterday night, the code was working and today, i reran the code and it results in an error
give the database a restart
restart it from its settings
ok. i was about to do it - but wanted to know whether that timescaledb extension issue and invalid length of startup had an issue.
ive seen that plenty, isnt a real problem
ok thanks
restarted, still same issue - both python code and Tableplus is not able to connect
any guidance to debug the issue in a step-by-step fashion?
try through a vpn?
i don't use vpn
i was asking you to use one to connect
try spinning up another postgres database and try connecting to that
sorry, i am not familiar with using vpn -how does that vpn step help? can you please help me understand
thats out of the scope of these help threads, sorry
let me know how this goes
sorry, i am new here, so i may not understand your rules and boundaries. since you asked me to connect using vpn, i wanted to understand how that helps in diagnosing the problem. i would like to understand the solution before trying it out - is that not ok?
its fine but i just dont want to explain what a vpn is
i thought everyone knows what vpns do
i know what vpn is, and i have used it connect to my corporate emails, but here in this specific step,i am not sure how it helps.
let me know how this goes
forget i asked about a vpn
sorry about the vpn discussion.
^
new db service up and running, but that is not connectable from tableplus. maybe, some issue with my network as i am in an another office today, may be they could have blocked some ports 🙂
yep that was what I was gonna tell you if you came back and said the new database doesn't work either
looks like your work has a firewall, try again when you are on your home network
is this why you are suggesting to use a VPN? since that can bypass the firewall? now, i am beginning to get it
yes exactly
ok, i have done research and downloaded a vpn client and able to connect. thanks for your help.
it would have been easier for me to try this step if you could have said something like this, Brody
---
there might be some firewall blocking issue that is preventing your DB client from connecting - a quick way to check this would be to use a VPN to bypass all firewall restrictions - if it works under VPN, then you know that the service is up and the root cause of the problem is the firewall.
though i have used a vpn client (some expensive client paid by my earlier employers), i never have used a free one for personal use - so, that is why i wanted to understand this step - as i need to install some new software
I didn't know it was a firewall issue at the time, I was just asking you to try basic debugging steps and didn't feel the need to explain something as mundine has what a VPN is
i see your point, Brody. sorry for giving you the trouble. have a nice day and thanks for helping me out
no worries!