Locating PostgreSQL data directory

Use a simple psql query to find the location of the data directory
postgres=# SHOW data_directory;
data_directory
------------------------------
/var/lib/postgresql/8.4/main
(1 row)

Or

postgres=# select setting from pg_settings where name = 'data_directory';
setting
------------------------------
/var/lib/postgresql/8.4/main
(1 row)

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.