1
0
mirror of https://github.com/jbranchaud/til synced 2026-01-02 22:58:01 +00:00
Files
til/postgres/find-the-data-directory.md
2015-10-31 18:55:33 -05:00

15 lines
472 B
Markdown

# 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
```sql
> show data_directory
```
Postgres will output the absolute path of the data directory.
[source](http://dba.stackexchange.com/questions/1350/how-do-i-find-postgresqls-data-directory)