Postgres Database was wiped?
jayshoe
PROOP

a year ago

Hello,

For some reason, my postgres database was wiped? It was good yesterday, and it's not there today. What happened?

Solved

8 Replies

jayshoe
PROOP

a year ago

I tried restoring some backups but it is still broken.


chandrika
EMPLOYEE

a year ago

Hi there, I’m seeing the volume attached has a flat usage of 1GB so presumably the data should still be there. Let’s try to find it for ya!

Could you please access and check the data within that volume? Possibly misconfigured on how it may be attached to the service


Status changed to Awaiting User Response Railway about 1 year ago


jayshoe
PROOP

a year ago

Hello, unfortunately this happened again. I suspect potential foul play?

When I mount the postgres volume it should be in /data right?


Status changed to Awaiting Railway Response Railway 12 months ago


a year ago

Postgres expects the volume to be mounted to /var/lib/postgresql/data.

If it is mounted to anything else, data will not persist.


Status changed to Awaiting User Response Railway 12 months ago


jayshoe
PROOP

a year ago

So when I go to mount a drive that's what I should put in there?


Status changed to Awaiting Railway Response Railway 12 months ago


a year ago

Correct.


Status changed to Awaiting User Response Railway 12 months ago


jayshoe
PROOP

a year ago

OK I restored the site.

Is that why the site would randomly loose it's data? Maybe the postgres database had to redeploy or something and because I wasn't using the right mount directory it would basically destroy the database?

Now that I'm using the right mount point maybe that should solve the issue and hopefully my data won't disappear again?


Status changed to Awaiting Railway Response Railway 12 months ago


a year ago

Yep that's exactly what happened. looks like you're g2g now 🙂


Status changed to Awaiting User Response Railway 12 months ago


Railway
BOT

a year ago

This thread has been marked as solved automatically due to a lack of recent activity. Please re-open this thread or create a new one if you require further assistance. Thank you!

Status changed to Solved Railway 11 months ago


Welcome!

Sign in to your Railway account to join the conversation.

Loading...