remote-postgres.adp
Delivered as text/html
Related Files
[ hide source ] | [ make this the default ]
File Contents
<property name="context">{/doc/acs-core-docs/ {ACS Core Documentation}} {Running a PostgreSQL database on another server}</property> <property name="doc(title)">Running a PostgreSQL database on another server</property> <master> <style> div.sect2 > div.itemizedlist > ul.itemizedlist > li.listitem {margin-top: 16px;} div.sect3 > div.itemizedlist > ul.itemizedlist > li.listitem {margin-top: 6px;} </style> <include src="/packages/acs-core-docs/lib/navheader" leftLink="database-management" leftLabel="Prev" title="Chapter 7. Database Management" rightLink="install-openacs-delete-tablespace" rightLabel="Next"> <div class="sect1"> <div class="titlepage"><div><div><h2 class="title" style="clear: both"> <a name="remote-postgres" id="remote-postgres"></a>Running a PostgreSQL database on another server</h2></div></div></div><p>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.</p><div class="itemizedlist"><ul class="itemizedlist" style="list-style-type: disc;"> <li class="listitem"> <p>Edit the database configuration file, which in a Reference install is located at <code class="computeroutput">/usr/local/pgsql/data/postgresql.conf</code> and change</p><pre class="programlisting">#tcpip_socket = false</pre><p>to</p><pre class="programlisting">tcpip_socket = true</pre> </li><li class="listitem"><p>Change the access control file for the database to permit specific remote clients to access. Access can be controlled ... (add notes from forum post)</p></li><li class="listitem"> <p>Change the OpenACS service's configuration file to point to the remote database. Edit <code class="computeroutput">/var/lib/aolserver/<span class="replaceable"><span class="replaceable">$OPENACS_SERVICE_NAME</span></span>/etc/config.tcl</code> and change</p><pre class="programlisting"></pre><p>to</p><pre class="programlisting"></pre> </li> </ul></div> </div> <include src="/packages/acs-core-docs/lib/navfooter" leftLink="database-management" leftLabel="Prev" leftTitle="Chapter 7. Database Management" rightLink="install-openacs-delete-tablespace" rightLabel="Next" rightTitle="Deleting a tablespace" homeLink="index" homeLabel="Home" upLink="database-management" upLabel="Up">