90 day restore to a new project - cannot connect with psql
Hi all,
I sadly lost my project due to the 90 day restriction and am going through the process of restoring it to a new project. A bit of a pain but hey ho.
I have downloaded the backup, created a windows subsytem linux environment and installed postgres client etc.
In Supabase I have clicked on the connect to get the connection string and have tried restoring the database but everytime I try I get the error message:
"psql: error: could not connect to server: Connection refused
Is the server running on host "db.????????.supabase.co" (2600:FFF:ff:ffff:ffff:ffff:ffff:fff) and accepting
TCP/IP connections on port 5432?"
I have waited 30 minutes to see if it was a password issiue done incorrectly and tried again but still the same error message. Am I missing something here?
Without being able to connect to the database I cannot restore my data which would be a real pain in the rear. Any and all help greatly appreciated?
Thank you
1 Reply
Solved my own issue. It was three issues why I was not able to connect. The first was the password had special characters in it so had to reset my password to a simple string of words instead.
The second was due to IPv4. Had to do a session connection so that IPv4 was allowed not a direct connection.
The third was connecting via a VPN. Supabase appears to restrict connections through VPNs. With the password change, the session connection string and the VPN disconnected, I was finally able to connect 🙂
Hope this helps someone else out there.