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.5.2.1 -r1.5.2.2 --- openacs-4/packages/acs-core-docs/www/remote-postgres.html 26 Aug 2005 00:02:30 -0000 1.5.2.1 +++ openacs-4/packages/acs-core-docs/www/remote-postgres.html 9 Apr 2006 22:26:16 -0000 1.5.2.2 @@ -1,11 +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 - Reference install is located at /usr/local/pgsql/data/postgresql.conf + 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 permit specific remote clients to access. Access can be 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 + /var/lib/aolserver/$OPENACS_SERVICE_NAME/etc/config.tcl and change

    to

View comments on this page at openacs.org