2 Replies Latest reply: Aug 6, 2011 5:18 AM by slv1970
slv1970 Level 1 Level 1 (0 points)

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


Mac Pro, Mac OS X (10.7)
  • 1. Re: mac os x server lion postgresql configure
    akmacix Level 1 Level 1 (10 points)

    /private/var/pgsql/pg_hba.conf

  • 2. Re: mac os x server lion postgresql configure
    slv1970 Level 1 Level 1 (0 points)

    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