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?
Thanks6 Replies
Project ID:
495180ac-2905-4ac4-b88c-e03e70a3298eProject ID: 495180ac-2905-4ac4-b88c-e03e70a3298e
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
then swap the source of the database from the docker image to your repo
Thank you. This is the advice I needed
no problem!
@jdmedlock were you able to make point in time recovery work?