Index: openacs-4/packages/acs-core-docs/www/remote-postgres.html =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/remote-postgres.html,v diff -u -r1.15 -r1.16 --- openacs-4/packages/acs-core-docs/www/remote-postgres.html 8 Nov 2017 09:42:12 -0000 1.15 +++ openacs-4/packages/acs-core-docs/www/remote-postgres.html 3 Sep 2024 15:37:32 -0000 1.16 @@ -1,29 +1,12 @@ -Running a PostgreSQL database on another server

Running a PostgreSQL database on another server

- - -

To run a database on a different machine than the +Running a PostgreSQL database on another server

Running a PostgreSQL database on another server

To run a database on a different machine than the webserver requires changes to the database configuration file and access control file, and to the OpenACS service's - configuration file.

-
  • -

    Edit the database configuration file, which in a + configuration file.

    • Edit the database configuration file, which in a Reference install is located at /usr/local/pgsql/data/postgresql.conf - and change

      -
      #tcpip_socket = false
      -

      to

      -
      tcpip_socket = true
      -
    • -

      Change the access control file for the database to + and change

      #tcpip_socket = false

      to

      tcpip_socket = true
    • Change the access control file for the database to permit specific remote clients to access. Access can be - controlled ... (add notes from forum post)

      -
    • -

      Change the OpenACS service's configuration file to + controlled ... (add notes from forum post)

    • Change the OpenACS service's configuration file to point to the remote database. Edit - /var/lib/aolserver/$OPENACS_SERVICE_NAME/etc/config.tcl - and change

      -
      
      -          

      to

      -
      
      -        
    -
+ /var/lib/aolserver/$OPENACS_SERVICE_NAME/etc/config.tcl + and change

to