Find The Data Directory

Where does postgres store all of the data for a database cluster? Well, in its data directory. Where exactly that data directory is can depend on how the database cluster was setup. Postgres can tell you right where to look, though. Within psql, run

> show data_directory

Postgres will output the absolute path of the data directory.

source

Last updated