v2 Database
Hey guys, sorry to bug you on this matter!
I read the docs regarding the database migration and I'm still a bit reluctant to do so at the moment cause of my inexperience with DB's. if you guys can answer these questions for me to ease my mind whenever you can I'd greatly appreciate it!
1. how long does migration take on average?
2. Is it a one-click operation where i won't have to do anything after? aside from updating any 'DATABASE_URL' instances
3. is there any common errors that i should keep an eye out for when updating just in case i can get a jump on debugging it?
*Note: for my web app i hired a developer to help me with connecting the DB + Authorization. The auth is pretty simple however, no user data is essentially saved, the web app checks if the user is subscribed via stripe by their email and they will have full access. So that being said worst-case scenario users just have to log in to be stored in the DB again. I just want to make sure i connect to the v2 DB successfully with minimal downtime! Thank you so much for your service Railway team!
*Note: for my web app i hired a developer to help me with connecting the DB + Authorization. The auth is pretty simple however, no user data is essentially saved, the web app checks if the user is subscribed via stripe by their email and they will have full access. So that being said worst-case scenario users just have to log in to be stored in the DB again. I just want to make sure i connect to the v2 DB successfully with minimal downtime! Thank you so much for your service Railway team!
15 Replies
Project ID:
N/A
N/A
1. sounds like you dont have much data, should only be a minute or two.
2. yes its one click, as long as you are using reference variables, e.g.
DATABASE_URL=${{Postgres.DATABASE_URL}}
if you are using that, you dont have to manually update anything.
3. not using reference variables, make sure you are using them as shown above.Perfect thank you so much for the prompt response @Brody ! I'll be upgrading the DB this weekend most likely when I see the traffic dying down a bit! I appreciate the help, cheers 🍻
no problem, but remember the deadline is jan 31st
For sure, thanks for the reminder!
Hey just confirmed with my developer that we are indeed using reference variables! The image is the database_url for my web app service.
Is there anything else to expect after I update just to be sure or will everything be good after the migration finishes? Will be pushing an update at around 12 am est!
![No description](https://cdn.answeroverflow.com/1198847681670414398/Screenshot_2024-01-21_at_11.20.00_PM.png)
the migration auto updates the reference variables making the transition as smooth as possible, but after the migration is done please confirm all data is in place in the new database and that your app is operating as it should, after that you are free to delete the legacy database
ill be around at 12am est, if anything goes wrong you can ping me
Awesome, I appreciate the help! will definitely ping you if anything goes wrong, will begin the migration right now!
Looks like everything was handled smoothly as you said man! thank you so much for that! just checked the app and its up and running! just to be sure my app is now connected to the new database right? i can delete the legacy db?
looks like all the data is intact as well!
as long as you say your data is in tact you can delete the legacy database
Great and just one more thing, i noticed this popup
![No description](https://cdn.answeroverflow.com/1198858404895133726/Screenshot_2024-01-22_at_12.14.54_AM.png)
should i click on that or am i good because im already using the variable reference
just a display bug, you're good
awesome thanks for the help again mate! will continue to monitor but its looking good so far!
no problem!