How to do PostgreSQL point in time recovery

chingu-service

PROOP

2 years ago

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

chingu-service

PROOP

2 years ago

Project ID: 495180ac-2905-4ac4-b88c-e03e70a3298e

brody

EMPLOYEE

2 years 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 

COPY recovery.conf

then swap the source of the database from the docker image to your repo

chingu-service

PROOP

2 years ago

Thank you. This is the advice I needed

brody

EMPLOYEE

2 years ago

no problem!

pepijn

PRO

2 years ago

@jdmedlock were you able to make point in time recovery work?

Welcome!