CODEWITHSUNDEEP
postgresqlgoogle-cloud-sqldata-recoverydisaster-recovery
Vikash Kumar
Vikash Kumar

Reputation: 197

GCP Cloud SQL Point-in-time recovery

I am working on DR for Cloud SQL. I found that we can enable Point in time recovery for Cloud SQL and get the data restored till a particular time in case of any data corruption. In the document, I found that we will have to create a clone after enabling point in time recovery. Creating a clone will create a new IP address for the cloned database. Will the admin credentials going to change when we create a clone of the database or is it going to be the same?

Upvotes: 0

Views: 3281

Answers (1)

Divyani Yadav
Divyani Yadav

Reputation: 1142

As mentioned in the link:

Point-in-time recovery allows you to recover an instance to a specific point in time. For example, if an operator ‘fat finger’ error causes a loss of data you can recover a database to the state it was just before the error occurred. It’s also great for testing your application and diagnosing issues since you can clone your live data to a testing database. See the point-in-time-recovery docs for more information.

Admin credentials will be the same for both databases. For more information you refer to the link where recovery with the Google Cloud SQL(postgreSQL) has been explained.

Upvotes: 1

Related Questions