This 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 :).