Point in Time Recovery for Cloud SQL for PostgreSQL

[aws developer]

Point in Time recovery is not yet available for Cloud SQL for PostgreSQL, however this is available for Cloud SQL for SQL. 

And may be available for Cloud Spanner (I do not know yet)?

=================

Here the situation is I want to achieve zero downtime year over year for my database.Let me start with cloud spanner: I can use cross region replication, however the issue would be with the operator errors like for example if an operator error causes a loss of data, I should be in a position to recover a database to its state before the error occurred.

I should be able to create stored procedures, restore any accidentally dropped/truncated tables, DB should be PCI compliant, support for SOAP/REST APIs,  a failover solution for a minute if google's infrastructure fails for a minute.

What do you guys think, could be a good option ?

[Yasser Karout]

Hello,

You can follow the following thread to stay up to date about PostgresSQL Point in Time recovery [1]. 

For Spanner the recommended method is the import/export feature to GCS [2][3]. You can use the Cloud Dataflow connector [4] to move data from Spanner to GCS periodically but this requires manual work and coding running Dataflow pipelines on your own.

Spanner also has global replication [5] meaning the data will always be available if one site is down and has strong consistency [6]. 

So based on your requirements, Spanner would likely be your best option. You can see a table comparing all database solutions as well here [7].

[1] https://issuetracker.google.com/78448400

[2] https://cloud.google.com/spanner/docs/import

[3] https://cloud.google.com/spanner/docs/export

[4] https://cloud.google.com/spanner/docs/dataflow-connector

[5] https://cloud.google.com/spanner/docs/replication#benefits_of_cloud_spanner_replication

[6] https://cloud.google.com/spanner/docs/true-time-external-consistency

[7] https://cloud.google.com/products/databases/