About jokester

jokester · 12-14-2023

Hi there,I'm the administrator of a 7TiB CloudSQL PostGreSQL database, which contains only 3TiB of relevant data. The automatic storage increase is enabled, and is an absolute requirement for our business.However trying to export some data, a team me...

jokester · 02-16-2024

Yes we did solved the issue. You have to reach GCP support to allowlistyour project to disk shrink API. Once enabled, we did performed tests on aclone db : 9h-10h were estimated.During shrink time, the instance is unavailable.Many tries were required...

jokester · 12-20-2023

Creating a New Instance with Desired Disk Size: Estimated time is about 55h to migrate, for either of these 2 solutions:* a Cloud SQL flat file export to a bucket* a Foreign Data Wrapper data copy We cannot afford this downtime.Consulting Google Clou...

jokester · 12-15-2023

Thank you for your reply.Modified Use of Database Migration Service (DMS):Our database get many new partitions a day. The DMS tools was not designed to address such use case, it will fail every time the schema changes. And I cannot accept 18 hours of...

My Stats

NoCommandLine's Bio

Badges jokester Earned

Recent Activity

CloudSQL cannot shrink disk

Re: CloudSQL cannot shrink disk

Re: CloudSQL cannot shrink disk

Re: CloudSQL cannot shrink disk