postgre database crashed
vinjung
PROOP

a month 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

10 Replies

Railway
BOT

a month 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

a month ago

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


jimmyb
FREE

a month 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

a month 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

a month ago

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


vinjung
PROOP

a month 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


Did this end up resolving your issue?


@sham435 Please do not use AI to blindly answer questions.


Loading...