R
Railway•6mo ago
jdmedlock

How to do PostgreSQL point in time recovery

I'm in the process of testing PostgreSQL point in time recovery and need to add/edit the recovery.conf file in pgdata. How can I access pgdata to do this and does anyone have advice for point in time recovery for a PostgreSQL instance hosted on Railway? Thanks
5 Replies
Percy
Percy•6mo ago
Project ID: 495180ac-2905-4ac4-b88c-e03e70a3298e
jdmedlock
jdmedlock•6mo ago
Project ID: 495180ac-2905-4ac4-b88c-e03e70a3298e
Brody
Brody•6mo ago
railway doesn't provide any kind of container file access or a native way to copy in files like your own recovery.conf into to pre built images. for this you would want to have a repo with a Dockerfile and your recovery.conf file with the Dockerfile looking something like this 
FROM <the postgres image railway uses>

COPY recovery.conf <the location that this file should be copied to>
FROM <the postgres image railway uses>

COPY recovery.conf <the location that this file should be copied to>
then swap the source of the database from the docker image to your repo
jdmedlock
jdmedlock•6mo ago
Thank you. This is the advice I needed
Brody
Brody•6mo ago
no problem!
Want results from more Discord servers?
Add your server
More Posts
my n8n installation crashed and now it wont come back in.It's saying that the database crashed. And now it wont load up. I have a crucial service running on Entire team is unable to loginThere seems to be an issue with logins for the past few days, only I who log in with GitHub can acceNot able to update my User DataI have successfully created schema and pushed db using Prisma but not able to populate the data whenPostgres QueryI am redeploying an old project of mine to a new database. For some reason, the new version of railwhow to unsubscribe my hobby plan billinghii hello, I used to use railway to deploy a project, but the project is no longer used and I want ttimeout errors when trying to configure azure mysql to railway backendhas anyone experienced time out errors in railway when fetching things from a azure database? CurrenSimple PHP Website Returns 404I've got a client website. It was originally an HTML website that we converted to PHP. There is a liHow to find Service ID - Docker Cache MountsHi, how can i find my service id? I have cache mounts in my dockerfile, and railway wants me to proPycairo error on deployHi. I new on discord so I hope I am in the right place to put this question. I got an deploy errFailing to deploy pnpm monorepo but was successful beforeHi, I'm new to railway so please bear with me. I have a learning side project which I organized in