Changed my postgres to metal and lost my data

andrea-twini
PRO

5 months ago

I've changed my database region to europe (previously it was US-1) and lost my volume connection. Then I've restored the database region to match the volume region (both US-1) but now I cannot connect to it (password authentication failed).

Solved

13 Replies

5 months ago

Hello,

The data tab can connect to the database, meaning the password is set correctly.

Please make sure you have the variables set correctly on your applications.

Best,
Brody


Status changed to Awaiting User Response Railway 5 months ago


andrea-twini
PRO

5 months ago

Hi! Thanks for your reply! The data tab is loading infinitely It's 6661663d-36cf-478a-9dea-da77e7ccdec7 dashboard-db service in 'staging' env.


Status changed to Awaiting Railway Response Railway 5 months ago


5 months ago

Ah gotcha, looks like you linked the incorrect service when creating this thread, so I was looking at the database in the production environment.

I've restored the password for you, but going forward please be more careful.


Status changed to Awaiting User Response Railway 5 months ago


Status changed to Solved brody 5 months ago


brody

Ah gotcha, looks like you linked the incorrect service when creating this thread, so I was looking at the database in the production environment.I've restored the password for you, but going forward please be more careful.

andrea-twini
PRO

5 months ago

Thank you! My bad for linking the wrong service I haven't understood what I did wrong tho; I've switched to metal instances through the UI and it hadn't warned about a password reset or smt.


Status changed to Awaiting Railway Response Railway 5 months ago


5 months ago

Changing the password was something you did, we do not change the password nor do we have any system to do that to begin with.


Status changed to Awaiting User Response Railway 5 months ago


andrea-twini
PRO

5 months ago

I can assure you that I did not change it; I'm not saying that you did it on purpose, maybe there's a bug that occurs when changing to metal instances. Btw the db now is empty and its table definitions are obsolete.


Status changed to Awaiting Railway Response Railway 5 months ago


From my side, I don't see the data browser broken anymore. Is this still the case that the data is not synced?


Status changed to Awaiting User Response Railway 5 months ago


andrea-twini
PRO

5 months ago

The data browser indeed works but the issue is that it'is connected to the wrong volume; this *apparatus-volume* contains some tables but thery're all empty and also they are the tables defined for chatbot-db, not dashboard-db! That's probably why I could not connect the volume to the container. The dashboard-db original volume is nowhere to be found Sorry I've just noticed that.


Status changed to Awaiting Railway Response Railway 5 months ago


That would explain it, I wouldn't know what happened to your original volume if you didn't delete it.


Status changed to Awaiting User Response Railway 5 months ago


angelo-railway

That would explain it, I wouldn't know what happened to your original volume if you didn't delete it.

andrea-twini
PRO

5 months ago

Me neither, if you look at the logs of 6 days ago when I changed the deployment of dashboard-db to metal in the Netherlands I don't see any log of a volume delete


Status changed to Awaiting Railway Response Railway 5 months ago


I am unsure then how to help you. No one else on the platform has reported something like this.


Status changed to Awaiting User Response Railway 5 months ago


andrea-twini
PRO

5 months ago

Luckily it was the staging environment so no worries. I won't do the migration on production tho for now


Status changed to Awaiting Railway Response Railway 5 months ago


echohack
EMPLOYEE

5 months ago

Understood andrea, is there anything else we can do to help?


Status changed to Awaiting User Response Railway 5 months ago


Railway
BOT

a month 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 about 1 month ago


Changed my postgres to metal and lost my data - Railway Help Station