问题描述
我最近开始修改Google Cloud SQL-PostgreSQL.
Ive recently started tinkering with Google Cloud SQL - PostgreSQL.
我创建了一个空数据库,并且在4-5天内,其存储使用量已增长到20GB以上.它只是一直在上升,但是数据库中没有数据.它甚至没有被使用.
I have created an empty database and over 4-5 days its storage usage has grown to over 20GB. Its just keeps going up, but there is no data in the database. Its not even being used.
有人知道该怎么做以及如何阻止它吗?
Does anyone know what would be doing this and how to stop it?
推荐答案
是的,这很可能是由于时间点恢复,每隔几分钟就会显示出存储量的增加.您可以在禁用时间点恢复的同时保持启用自动备份的功能.一旦禁用它,二进制日志将被删除,您会发现存储使用量立即减少.也就是说,根据文档:二进制日志及其关联的自动备份会自动删除,通常会在7天后发生."
Yes, this is most likely due to Point-in-time recovery which will show an increase to your storage every few minutes. You are able to keep automated backups enabled while disabling point-in-time recovery. Once you disable it the binary logs will be deleted and you will notice an immediate reduction in storage usage. That said, according to the documentation: "The binary logs are automatically deleted with their associated automatic backup, which generally happens after about 7 days."
要禁用时间点恢复,请执行以下操作:
To disable point-in-time recovery:
- 选择您的实例
- 选择备份
- 在设置"下,选择编辑"
- 取消选中用于时间点恢复的复选框
这篇关于Google Cloud SQL-Postgresql的存储不断增长的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!