Обсуждение: 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