Find PostgreSQL data dir from PostgreSQL
AnnexeThis post originally appeared on the Annexe.
Assuming you can access your database:
postgres=# SHOW data_directory
On Debian Wheezy with the official PostgreSQL repo, the default will show:
data_directory
---
/var/lib/postgresql/9.3/main
(1 row)
Too easy :).