Thread: Access to pg_hba.conf
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?
Jane
On 18/11/11 23:27, "Jane Geering" <jane.geering@gmail.com> wrote: > 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? You can do it by: $sudo su $password #su postgres bash3.2: whoami bash3.2: _postgres Which will give you access to all postgres directories & files. But there is probably a much better solution on its way to you from more learned members than I ;-)... Cheers, Phil. -- Nothing to see here... move along, move along
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.confI 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?Jane
Thanks Phil. Got it.
On Sat, Nov 19, 2011 at 9:57 AM, Jane Geering <jane.geering@gmail.com> wrote:
Jane
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?Jane