[an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] Database Setup
Gold User's Guide
<<< Previous Installation Next >>>

Database Setup

If you have chosen to use PostgreSQL, you will need to configure the database to support Gold connections and schema. No setup is needed if you are using SQLite.

Initialize the database (if you installed from tarball).

[postgres]$ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data

Add the IP ADDRESS of the host where the Gold server will run (even if it is the same host as the database server).

[postgres]$ echo "host all all 192.168.1.1 255.255.255.255 trust" >>/usr/local/pgsql/data/pg_hba.conf

Startup postgres with the -i option to allow internet domain sockets

[postgres]$ /usr/local/pgsql/bin/postmaster -i -D /usr/local/pgsql/data >/var/log/pgsql 2>&1 &

Add the "gold" user as a database administrator

[postgres]$ /usr/local/pgsql/bin/createuser gold

Shall the new user be allowed to create databases? y
Shall the new user be allowed to create more new users? n

Create the Gold database

[scottmo]$ /usr/local/pgsql/bin/createdb gold

Edit the Gold configuration files.

[scottmo]$ vi /opt/gold/etc/goldd.conf

[scottmo]$ vi /opt/gold/etc/gold.conf

<<< Previous Home Next >>>
General Setup Up Web Server Setup
[an error occurred while processing this directive] [an error occurred while processing this directive]