Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

I am using PostgreSQL on Mac, I have created several databases using command line. I am looking into /Library/PostgreSQL/9.2/data and I can not see any .dat file. Am I looking into the wrong place for data files?

I have used the following command: ps auxw | grep postgres | grep -- -D as mentioned postgresql database default location on linux and it gives me the /Library/PostgreSQL/9.2/data directory.

Any ideas?

share|improve this question
2  
select setting from pg_settings where name = 'data_directory' shows you the real path of the data directory (you must be connect to PostgreSQL as a superuser) – a_horse_with_no_name Jan 4 at 16:59
Do not know about Mac. If this can help, in my Linux box they are located under /var/lib/pgsql/data/. Anyway, the files are only visible for the user postgresql. May be your files are there but hidden for your current user. – jap1968 Jan 4 at 17:04

2 Answers

up vote 1 down vote 
select setting from pg_settings where name = 'data_directory'
and 
ps auxw | grep postgres | grep -- -D

both generate the same result. The first one through postgresql, second one command line. Thanks to @a_horse_with_no_name

share|improve this answer
up vote 1 down vote

PostgreSQL lets you store data in relatively arbitrary locations in the filesystem. The default location, which you can get with show data_directory, isn't the whole story.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.