Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Novice > editing pg_hba....
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 3146 of 3323
Post > Topic >>

editing pg_hba.conf

by ej@[EMAIL PROTECTED] (Eric Jarvies) Jun 24, 2008 at 07:59 PM

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


-- 
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
 




 2 Posts in Topic:
editing pg_hba.conf
ej@[EMAIL PROTECTED] (Er  2008-06-24 19:59:16 
Re: editing pg_hba.conf
pgsql@[EMAIL PROTECTED]   2008-06-26 13:01:11 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Dec 5 5:38:53 CST 2008.