postgres data lost
leoismyfriend
HOBBYOP

a month ago

i had an issue with my domain at aws route 53 and needed it recovered.

Once I got my domain back, I've been having trouble connecting to my db (SSL error) with my server and I don't see the 'Data' anymore in the Postgres UI. I only see backups and since I'm on Hobby plan I guess I don't get auto backups.

I can setup a new PG db and that seems to work fine but I can't access my data from my former DB now.

Where is my data? Can it be recovered and I can migrate it to a new PG db where I don't have SSL issues?

Solved

3 Replies

sam-a
EMPLOYEE

a month ago

You have two services in your project - Postgres and Postgres-mdoW. The Data tab only appears on database services deployed from Railway's database templates. If Postgres-mdoW was deployed from a GitHub repo, it won't have a Data tab since it's not a database service. Your data should be in the original Postgres service. Can you check if the Postgres service has the Data tab and shows your tables?


Status changed to Awaiting User Response Railway 26 days ago


leoismyfriend
HOBBYOP

a month ago

yeah, so Postgres-mdoW was actually the original database with all the data. It'd been around for months now. I spent all day yesterday trying to connect to it from the app but I couldn't for various SSL reasons and I saw no Data tab at all in the UI.

The other 'Postgres' volume was just something I launched yesterday as a hail mary just to see if I had those same SSL / connection issues as mdoW and it did not. It has none of the original data, which makes me wonder where the original data went.


Status changed to Awaiting Railway Response Railway 26 days ago


a month ago

You are deploying a GitHub repo onto the Postgres service. I have reverted that for you. Your data tab is restored and accessible.

Now, obviously, these are your services, and you are free to do what you want with them, but I would advise not to mess about with services that may hold critical data, as we do not typically help restore something after it has been misconfigured.


Status changed to Awaiting User Response Railway 26 days ago


Railway
BOT

19 days ago

This thread has been marked as solved automatically due to a lack of recent activity. Please re-open this thread or create a new one if you require further assistance. Thank you!

Status changed to Solved Railway 19 days ago


Loading...