Why Can’t I Shrink My Database Disk?

TL;DR

Database disks cannot be resized downward on Aptible or any major cloud platform (AWS, Azure, GCP). You can scale up disk space, but shrinking a disk in place is not supported. This is because cloud storage systems cannot guarantee which parts of the disk are safe to discard without risking data loss. To reduce disk size, you must migrate to a new instance with a smaller disk volume, using dump/restore or replication.

Why You Can’t Shrink a Database Disk

This isn’t just an Aptible limitation — it’s a universal constraint across modern cloud platforms:

• Cloud Volumes vs. Partitions:
  A database disk is backed by a cloud storage volume (like AWS EBS). Cloud volumes can only be grown, never reduced. While operating systems sometimes allow shrinking partitions, that assumes you can fully defragment and pack all data blocks safely. In a cloud environment, the provider cannot make those assumptions.

• How Block Storage Works:
  Block storage writes data across many sectors of a volume, often non-sequentially. The cloud provider cannot know for certain which blocks are “unused.” Shrinking could destroy valid data, so it’s fundamentally not allowed.

• Physical vs. Cloud Environments:
  On a personal computer or physical server, it may be possible to shrink a disk partition by booting into a utility that moves blocks into a smaller contiguous area. In cloud computing, that process isn’t feasible, so providers only allow expansion.

• Risk of Data Loss:
  If a provider tried to automatically shrink your disk, it could wipe out data in areas it incorrectly assumed were free. To avoid this risk, shrinking is universally disallowed.

What to Do Instead

If you need a smaller database disk, the safe options are:

• Dump and Restore
  Export your database (e.g., using pg_dump or mysqldump) and import it into a new database provisioned with the smaller disk size you want.

• Replica and Failover
  Create a replica database with a smaller disk size (if supported by your database type), let it catch up, and then fail over to it.

See Aptible docs for details: Database Scaling – Disk Scaling.

Key Takeaway

You can always scale up disk size, but never down in place. This universal limitation generally applies across all cloud providers, not just Aptible. If you need to reduce your disk footprint, the path is to migrate your data into a new instance with a smaller volume.