a month ago
I have an issue similar to this:
https://station.railway.com/questions/trying-to-add-a-volume-to-postgres-vecto-5d14fb3e
But I'm now in a different situation.
The database is working with out a mounted volume, I can't see the data in the UI, but I can access the database and the service is working, but I can't use backups / access the data etc.
It all started when adding pgvector, and now there's a floating unmounted volume with OLD data and structure, there's pgvector with a volume which I can't see the data tab in the UI, and there's a PostgressSQL without any mounted volume, but that it's operating.
Ideally I want to have a volume that's backed-up on the postgress sql and be able to access the data tab in the UI as well. All of this without losing the current data. The unmounted volume is old data as far as I know (I just want to make sure it's not being used at the moment).
4 Replies
a month ago
This thread has been marked as public for community involvement, as it does not contain any sensitive or personal information. Any further activity in this thread will be visible to everyone.
Status changed to Open Railway • about 1 month ago
a month ago
Your database is currently writing to the container's temporary file system. So you must not restart/redeploy your database service or you'll lose your data. You should backup your data using pg_dump before performing any other steps to avoid data loss.
Example backup command: pg_dump -d <DATABASE_URL> -Fc -f path/to/file.backup .
If the unmounted volume contains old data that you don't need, create a new volume, and attach it your db, then run pg_restore
command.
Once you attach your volume to the db the data tab in the UI should be accessible.
Please keep in mind that you should try this method only if the old data in the unmounted volume in not needed. It's a safe method as long as you backup your current service data, and create/restore to a new volume, and don't delete the old unmounted volume.
a month ago
Thanks, I've setup a new volume, and restored the data.
I can enable backups now, but I can't see the "Data" tab like I had before.
Can you help me first make sure this is setup correctly and help me understand how do I see the data tab?
Thanks,
Elad
a month ago
If you've attached the new volume to the postgres service and restored data, you should be able to see the "Data" tab. Can you send an image so I can see?