I created this template to make it easier. Make sure to make a backup of the source DB before using it, and target DB must be clean.

https://railway.com/deploy/postgres-migrator

ill give it a go now and see how it goes

im having issues, but i dont think it has anything to do with your template

i cant seem to add a Postgres 16 service, everytime i add a new one it installs 17 and my prod db is v16 according to the logs of the script

You can always pg_dump and pg_restore, jus make sure you got backups in place before that.

yeah i was thinking i might just have to go low-level

**In that fresh DB instance, with no data: **
Go into the Service Settings -> Source Image -> Click the pen icon -> at the end of the image source replace 17 with 16.

It will crash because of the version diff, just wipe the attached volume and it will redeploy correctly.

and as always, make sure you have backups

I don't think Postgres can do a major version downgrade.

yeah i did try that and it gave me some critical errors

i could upgrade my prod db, really.. i have a recent backup

Yeah, u also need to wipe the volume

im trying to save my data <:kekw:788259314607325204>

Medim is saying that in reference to the Postgres 17 service, not your original database.

yeah i realised. ill give it a go!

thanks for all your help so far

Keep us updated <:salute:1137099685417451530>