Sample Header Ad - 728x90

How do I find PostgreSQL's data directory?

209 votes
17 answers
361522 views
I forgot how I started PostgreSQL the last time (it was months ago) and I don't remember where the data directory is located. The postgres command seems to require the location of the data directory. I'm on MacOsX if that helps. /usr/local/postgres doesn't exist on my Mac. Using the answers provided below, I found that it was here: /usr/local/var/postgres
Asked by randomguy (2231 rep)
Feb 20, 2011, 12:10 PM
Last activity: Jun 15, 2022, 10:09 AM