postgre database crashed

vinjung
PROOP

10 days ago

After upgrading the PostgreSQL database to 80GB, a crash occurred during deployment. I’m currently on the Pro plan, and it would be a disaster if the data gets deleted. How can I resolve this issue?

$10 Bounty

8 Replies

Railway
BOT

10 days ago

Hey there! We've found the following might help you get unblocked faster:

If you find the answer from one of these, please let us know by solving the thread!


Railway

Hey there! We've found the following might help you get unblocked faster: - [🧵 Crash after railway metal upgrade](https://station.railway.com/questions/crash-after-railway-metal-upgrade-3056fc65) - [🧵 Database data is gone after Railway Metal upgrade](https://station.railway.com/questions/database-data-is-gone-after-railway-meta-b7595f93) - [🧵 My site not working after upgrade raillway database](https://station.railway.com/questions/my-site-not-working-after-upgrade-raillw-ba740b8f) If you find the answer from one of these, please let us know by solving the thread!

vinjung
PROOP

10 days ago

I couldn’t find a solution from the information provided.


jimmyb
FREE

10 days ago

Can you check your logs to see why the crash occurred? Is there any specific error message showing up that you can share? You can see more about reviewing your services logs here - https://docs.railway.com/guides/logs

Do you have any backups of your database in case if there was any corruption? Were you able to bring the PostgreSQL service back online or is stuck in a crash loop?


vinjung
PROOP

10 days ago

I increased the volume while the database was running.

When the change didn’t seem to take effect, I thought, “Huh? That’s strange,” and tried increasing the volume again.

I didn’t create a backup, and it’s currently stuck in a crash loop.

I can’t copy and paste the contents of the logs into the reply.


vinjung

I increased the volume while the database was running.When the change didn’t seem to take effect, I thought, “Huh? That’s strange,” and tried increasing the volume again.I didn’t create a backup, and it’s currently stuck in a crash loop.I can’t copy and paste the contents of the logs into the reply.

Can you share the logs?


samgordon

Can you share the logs?

vinjung
PROOP

10 days ago

I couldn’t copy the contents, so I uploaded them as an attachment.


vinjung
PROOP

10 days ago

I couldn’t copy the contents, so I uploaded them as an attachment.

Attachments


Your database is not in a good state. Please create a backup before proceeding.

Look at this stack overflow comment. Try out what they suggested. Let me know if you need help.

https://stackoverflow.com/a/8812934