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
Featured on Community
Get our biweekly newsletter
Sign up for Infrastructure as a Newsletter.
Hollie's Hub for Good
Working on improving health and education, reducing inequality, and spurring economic growth? We'd like to help.
Become a contributor
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
