You can either use 'sudo' to 'cd' to that DATA directory, OR 'sudo su - postgres' (assuming you have 'postgres' added as the user while installation) - then you are free to traverse the $PG_DATA directory.
Arvind
From: Jane Geering <jane.geering@gmail.com> To: postgresql novice <pgsql-novice@postgresql.org> Sent: Friday, November 18, 2011 3:27 PM Subject: [NOVICE] Access to pg_hba.conf
I have a functioning PostgreSQL 9.1.1 installation on a Mac OSX 10.6.8 machine, installed using EnterpriseDB one-click installer. The data files are (presumably) in /Library/PostgreSQL/9.1/data/.
From my reading of the docs I believe this is where pg_hba.conf will be found. What do I have to do to gain access to the files in the /data directory? Tried RTFM but frankly am too intellectually challenged to understand. Can anyone help?
