Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

mac os x server lion postgresql configure

tell me where are the files postgresql.conf pg_hba.conf

Mac Pro, Mac OS X (10.7)

Posted on Aug 5, 2011 6:10 AM

Reply
Question marked as Best reply

Posted on Aug 5, 2011 6:25 AM

/private/var/pgsql/pg_hba.conf

2 replies

Aug 6, 2011 5:18 AM in response to slv1970

to connect to another computer, I did



1. edit file /system/library/LaunchDaemons/org.postgresql.postgres.plist



deteteв lines

<string>-c</string>

<string>listen_addresses=</string>

2. edit file /var/pgsql/pg_hba.conf



add lines

host all all 192.168.0.0/24 trust

3. edit file /var/pgsql/postgresql.conf

edit lines

#listen_addresses = 'localhost'

listen_addresses = '*'

#port = 5432

port = 5432

4. restart mac os x server


connect ok

mac os x server lion postgresql configure

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.