Postgres Database was wiped?
jayshoe
PROOP

8 months 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

8 months ago

I tried restoring some backups but it is still broken.


chandrika
EMPLOYEE

8 months 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 8 months ago


jayshoe
PROOP

7 months 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 7 months ago


7 months 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 7 months ago


jayshoe
PROOP

7 months ago

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


Status changed to Awaiting Railway Response Railway 7 months ago


7 months ago

Correct.


Status changed to Awaiting User Response Railway 7 months ago


jayshoe
PROOP

7 months 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 7 months ago


7 months ago

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


Status changed to Awaiting User Response Railway 7 months ago


Railway
BOT

7 months 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 7 months ago


Loading...