specca
specca
RRailway
Created by pierre on 1/7/2024 in #✋|help
deleted my postgres database by accident, any way to recover?
No description
53 replies
RRailway
Created by pierre on 1/7/2024 in #✋|help
deleted my postgres database by accident, any way to recover?
Great, will give it a shot and hope for the best. Thank you for all the help in any event!
53 replies
RRailway
Created by pierre on 1/7/2024 in #✋|help
deleted my postgres database by accident, any way to recover?
Yeah, my bad. I forgot about that, but yes that's the only migration it had been through.
53 replies
RRailway
Created by pierre on 1/7/2024 in #✋|help
deleted my postgres database by accident, any way to recover?
and ok, will try this one
53 replies
RRailway
Created by pierre on 1/7/2024 in #✋|help
deleted my postgres database by accident, any way to recover?
Perhaps it is because of the railway database v2 migration? (https://community.railway.app/announcements/databases-v2-migration-983074c7)
53 replies
RRailway
Created by pierre on 1/7/2024 in #✋|help
deleted my postgres database by accident, any way to recover?
No description
53 replies
RRailway
Created by pierre on 1/7/2024 in #✋|help
deleted my postgres database by accident, any way to recover?
will do!
53 replies
RRailway
Created by pierre on 1/7/2024 in #✋|help
deleted my postgres database by accident, any way to recover?
53 replies
RRailway
Created by pierre on 1/7/2024 in #✋|help
deleted my postgres database by accident, any way to recover?
the same way, through add new +
53 replies
RRailway
Created by pierre on 1/7/2024 in #✋|help
deleted my postgres database by accident, any way to recover?
with the add new button
53 replies
RRailway
Created by pierre on 1/7/2024 in #✋|help
deleted my postgres database by accident, any way to recover?
Yes. the db was created, and schema would have been pushed from prisma using prisma db push
53 replies
RRailway
Created by pierre on 1/7/2024 in #✋|help
deleted my postgres database by accident, any way to recover?
out of curiosity, is it possible to download the volume of data? I was thinking if so, I could try and access it locally from within a docker container where I can try and either use the older version of postgres or upgrade the database to work with v16
53 replies
RRailway
Created by pierre on 1/7/2024 in #✋|help
deleted my postgres database by accident, any way to recover?
it was deployed
53 replies
RRailway
Created by pierre on 1/7/2024 in #✋|help
deleted my postgres database by accident, any way to recover?
No description
53 replies
RRailway
Created by pierre on 1/7/2024 in #✋|help
deleted my postgres database by accident, any way to recover?
Great, thank you. I will give it a try and update the thread if I find a solution.
53 replies
RRailway
Created by pierre on 1/7/2024 in #✋|help
deleted my postgres database by accident, any way to recover?
Sorry, I'm not sure I understand. I have a new postgres service running in the project, which has a new set of variables, e.g. the db url, host name, port, etc. I have also mounted the pgdata to this service (by clicking mount in the dashboard). When you say that I need to use the old username and password, do you mean that I update the existing POSTGRES_USER and POSTGRES_PASSWORD variables within this service to match those of my previous service?
53 replies
RRailway
Created by pierre on 1/7/2024 in #✋|help
deleted my postgres database by accident, any way to recover?
Ok, that's promising. Thanks. I do have a record of the username and pw. Is there anything I'd need to do beyond just updating that info within the Postgres variables tab on my project dashboard?
53 replies
RRailway
Created by pierre on 1/7/2024 in #✋|help
deleted my postgres database by accident, any way to recover?
Hi, unfortunately I'm in the same boat... I had two projects open and deleted my instance of psql from the wrong one. I do still have a volume, 'Postgres data' which is present in my project dashboard and I can 'mount to service'. Is there any way that I can use this to restore the previous data? Thanks in advance for any help!
53 replies