QuestionQ48

VerifiedMigrate data solutions

You run a Cloud SQL for PostgreSQL 13 Enterprise Edition instance. An audit finds that the write-ahead logs used for point-in-time recovery (PITR) are stored on disk. You need PITR logs to be stored in a Cloud Storage bucket going forward. How can you do this without reducing recoverability or losing the existing PITR logs?

Explanation

For an eligible Cloud SQL Enterprise instance, an in-place upgrade to Cloud SQL Enterprise Plus automatically changes the storage location of PITR write-ahead logs from disk to Cloud Storage. This transition preserves the PITR process, whereas disabling PITR breaks the current transaction-log chain and changing retention only changes how long logs are kept.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!