By default, the Makefile.install prerequisite installer does not install the PostgreSQL 9 database server required by every Evergreen system; for production use, most libraries install the PostgreSQL database server on a dedicated machine. You can install the packages required by Debian or Ubuntu Lucid on the machine of your choice using the following commands as the root Linux account:

(Debian and Ubuntu Lucid) Installing PostgreSQL 9.1 server packages. 

make -f Open-ILS/src/extras/Makefile.install install_pgsql_server_backport_debs_91

(Ubuntu Precise) Installing PostgreSQL 9.1 server packages. 

make -f Open-ILS/src/extras/Makefile.install install_pgsql_server_debs_91

You can install the packages required by Fedora on the machine of your choice using the following commands as the root Linux account:

(Fedora) Installing PostgreSQL server packages. 

make -f Open-ILS/src/extras/Makefile.install install_fedora_pgsql_server
postgresql-setup initdb

For a standalone PostgreSQL server, install the following Perl modules as the root Linux account:

(Debian / Ubuntu) Installing additional Perl modules on a standalone PostgreSQL 9 server. 

aptitude install gcc libxml-libxml-perl libxml-libxslt-perl
cpan Business::ISBN
cpan JSON::XS
cpan Library::CallNumber::LC
cpan MARC::Record
cpan MARC::File::XML
cpan UUID::Tiny
cpan Rose::URI

(Fedora) Installing additional Perl modules on a standalone PostgreSQL 9 server. 

yum install gcc perl-XML-LibXML perl-XML-LibXSLT perl-Business-ISBN
yum install perl-Library-CallNumber-LC perl-MARC-Record perl-MARC-Charset
yum install perl-MARC-File-XML perl-UUID-Tiny

You need to create a PostgreSQL superuser to create and access the database. Issue the following command as the postgres Linux account to create a new PostgreSQL superuser named evergreen. When prompted, enter the new user’s password:

createuser -s -P evergreen

Once you have created the evergreen PostgreSQL account, you also need to create the database and schema, and configure your configuration files to point at the database server. Issue the following command as the root Linux account from inside the Evergreen source directory, replacing <user>, <password>, <hostname>, <port>, and <dbname> with the appropriate values for your PostgreSQL database (where <user> and <password> are for the evergreen PostgreSQL account you just created), and replace <admin-user> and <admin-pass> with the values you want for the egadmin Evergreen administrator account:

perl Open-ILS/src/support-scripts/eg_db_config --update-config \
       --service all --create-database --create-schema --create-offline \
       --user <user> --password <password> --hostname <hostname> --port <port> \
       --database <dbname> --admin-user <admin-user> --admin-pass <admin-pass>

This creates the database and schema and configures all of the services in your /openils/conf/opensrf.xml configuration file to point to that database. It also creates the configuration files required by the Evergreen cgi-bin administration scripts, and sets the user name and password for the egadmin Evergreen administrator account to your requested values.