8 months ago
I needed to increase RAM memory in my production postgres and the data and tables disappeared, can you help me urgently as this is my production environment?
4 Replies
8 months ago
Hello,
You have the volume mounted at /bitnami and that is not the correct mount point for Postgres.
This means that Postgres is saving all data to the temporary ephemeral file storage.
Unfortunately, since Postgres was configured to write data to ephemeral file storage we cannot accommodate the request to restore data.
The correct mount path is /var/lib/postgresql/data please set that up correctly going forward.
Best,
Brody
Status changed to Awaiting User Response Railway • 8 months ago
8 months ago
But what about backups?
I can't afford to lose this data. And this information is new to me, it was never clear when I created the database service.
Status changed to Awaiting Railway Response Railway • 8 months ago
8 months ago
Can you please help me in any way?
This was not clear when we created the volume when starting a postgres service. I migrated from AWS to here because we had good experiences with other projects, but this was indeed not clear.
8 months ago
Hello,
The database service deploys with the correct mount path, changing it to /bitnami was something you did.
Since this issue is user-initiated, we cannot accommodate a request to restore data, as that data was stored in ephemeral storage.
Backups also do not help here; a backup backs up the data in the volume, and with the mount path incorrectly configured, no data was ever written to the volume.
Best,
Brody
Status changed to Awaiting User Response Railway • 8 months ago
5 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 • 6 months ago