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

Learn How To Move a PostgreSQL Data Directory to a New Location on Ubuntu 22.04
20.04

How To Move a PostgreSQL Data Directory to a New Location on Ubuntu 20.04

Learn How To Move a PostgreSQL Data Directory to a New Location on Ubuntu 20.04
18.04

How To Move a PostgreSQL Data Directory to a New Location on Ubuntu 18.04

Learn How To Move a PostgreSQL Data Directory to a New Location on Ubuntu 18.04
16.04

How To Move a PostgreSQL Data Directory to a New Location on Ubuntu 16.04

Learn How To Move a PostgreSQL Data Directory to a New Location on Ubuntu 16.04

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.