From: | Eric Jarvies <ej(at)csl(dot)com(dot)mx> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | editing pg_hba.conf |
Date: | 2008-06-25 01:59:16 |
Message-ID: | 271D6663-5E6C-412D-BF60-EFBC0E49409E@csl.com.mx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
hello,
i have installed postgresql, and it's up and running fine, using the
postgres user account. however, when i run the pgadmin III utility,
and attempt to File>Open pg_hba.conf file, i cannot select it from
it's /data folder because it is obviously locked. i am using my
default os x user account, and so i clearly to not have access to that
postgres user folder. although i have a postgres user account, i do
not have a postgres user account listed under my Preferences >
Accounts. should i create one here? or is there any way to make the
existing postgres account visible in my Accounts list?
so, the question is; what would i need to do in order to make that
file easily selectable/editable using the pgadmin III utility
File>Open pg_hba.conf? whilst remaining logged in using my default os
x user account?
i would prefer being able to use pgadmin to edit this file, instead of
having to use Terminal > sudo su > su -l postgres > vi/emacs
pg_hba.conf. also, i have not had much success in using vi or emacs
to edit the file, because it is read only, and i haven't been able to
figure out how to overcome that(i've shut down the postgresql server).
thus, any advice would be greatly appreciated.
thanks,
eric jarvies
From | Date | Subject | |
---|---|---|---|
Next Message | P Kapat | 2008-06-25 22:14:49 | how to replicate a database from one machine to the other? |
Previous Message | Steve Crawford | 2008-06-23 16:42:22 | Re: table oids and comments |