Cloud SQL PostgreSQL Point in time recovery

[Jonathan Sou]

Does anyone have any solutions to implementing a point in time recovery on a PostgreSQL hosted on GCP?

A couple ways that I have found that could be a potential solution is if Cloud SQL PostgreSQL could create an external read replica so that I would be able to have the replica update the write ahead log file every time it changes, or somehow get access to the CloudSQL write ahead logs. To my knowledge, I don't think these features have been implemented yet.

Any suggestions or leads will be helpful. Thank you.

[Katayoon (Cloud Platform Support)]

Hi Jonathan,

I should note that Point-in-time recovery for Cloud PostgreSQL isn't available at this time, however there is a feature request on it and the Cloud SQL product team are evaluating this feature request. You may star it for further updates.