[google-cloud-sql-discuss] Re: Point in Time Recovery for Cloud SQL for PostgreSQL

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/

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/b64d2512-3f9c-404a-b4be-4d01ecf9f38e%40googlegroups.com.