How to Move a PostgreSQL Data Directory to a New Location
Databases grow over time, sometimes outgrowing the space on their original file system, and potentially leading to I/O contention. Whether you’re adding more space, evaluating ways to optimize performance, or looking to take advantage of other storage features, this tutorial will guide you through relocating PostgreSQL’s data directory. Select your operating system below to get started.
Ubuntu
22.04
How To Move a PostgreSQL Data Directory to a New Location on Ubuntu 22.04
By Melissa Anderson, Mark Drake, Jeanelle Horcasitas20.04
How To Move a PostgreSQL Data Directory to a New Location on Ubuntu 20.04
By Melissa Anderson, Mark Drake, Jeanelle Horcasitas18.04
How To Move a PostgreSQL Data Directory to a New Location on Ubuntu 18.04
By Melissa Anderson, Mark Drake16.04
How To Move a PostgreSQL Data Directory to a New Location on Ubuntu 16.04
By Melissa Anderson
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.