R
Railway•11mo ago
hyrme

Postgres database legacy migration stuck in "migrating data"

for 45 minutes now. The db is not that big, pg_dump and import would take a couple of minutes. Also noticed that the migration is adding to my usage. I am not sure I can interrupt the process without losing data - but then i don't also want to hit any overage charges.
24 Replies
Percy
Percy•11mo ago
Project ID: 4501ee61-00b6-421b-afd6-edae65fd1423
hyrme
hyrme•11mo ago
4501ee61-00b6-421b-afd6-edae65fd1423
Brody
Brody•11mo ago
you can cancel it, there's extremely low risk of data loss
hyrme
hyrme•11mo ago
what should the process be? Do I cancel, stop and remove the new pg db and migration - and repeat?
Brody
Brody•11mo ago
correct but, it sounds like you're familiar with pg_dump and pg_restore? if the auto migrations fails again you could spin up a new database yourself and do the dump and restore manually?
hyrme
hyrme•11mo ago
how do I cancel the migration though. I clicked on the legacy service - but there is no option to cancel. do I just hit restart database?
Brody
Brody•11mo ago
I've actually not ran this process myself, can you show me some screenshots of what you're looking at?
hyrme
hyrme•11mo ago
this is what shows up on the screen when I click on migration status
No description
Brody
Brody•11mo ago
maybe try deleting the new database
hyrme
hyrme•11mo ago
you are confident - I wont mess up my db? 😨
Brody
Brody•11mo ago
as long as you don't delete the wrong database you'd also want to delete the migration service
hyrme
hyrme•11mo ago
ok - completed manually now. I had a backup so wasnt worried about losing data. Thanks for the guidance. I noticed now that the new PG has a volume/disk attached. The legacy did not. Does this mean I will get charged for disk usage as well as memory usage? Previously only memory was being used/charged for.
Brody
Brody•11mo ago
thats correct $0.25 / GB
hyrme
hyrme•11mo ago
interesting.. do you know if by any chance memory usage will go down?
Brody
Brody•11mo ago
whats it at right now? you could always restart the database
hyrme
hyrme•11mo ago
I was hovering at around 700Mb in the legacy - still about the same in the new one.
Brody
Brody•11mo ago
oh then no its not gonna go down
hyrme
hyrme•11mo ago
its not a big amount - but it means i will be paying slightly more going forward. Its not much - but still hurts a bit! thanks!
Brody
Brody•11mo ago
youd said both databases used around 700mb of memory, so in terms of that you will be paying the same whats your disk usage at?
hyrme
hyrme•11mo ago
about a Gb So thats the incremental amount.
Brody
Brody•11mo ago
are you pro?
hyrme
hyrme•11mo ago
no still on hobby no worries. I have to drop now. will check in later. thanks again
Brody
Brody•11mo ago
sounds good, only asked since discord says youre not on either hobby or pro and was wondering how you where able to fill a disk with 1gb of data 🤣
hyrme
hyrme•11mo ago
i havent verified my account i guess.
Want results from more Discord servers?
Add your server