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)
Apple Event: May 7th at 7 am PT
tell me where are the files postgresql.conf pg_hba.conf
Mac Pro, Mac OS X (10.7)
/private/var/pgsql/pg_hba.conf
/private/var/pgsql/pg_hba.conf
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