Changes between Version 7 and Version 8 of sysadminPostgreSQLConfiguration

Timestamp:

Jun 23, 2009, 6:06:18 PM (14 years ago)

Author:

risard

Comment:

--

sysadminPostgreSQLConfiguration

@@ -140 +140 @@
 
 ----
-== Installing the Evergreen Schema ==
+== Creating the Evergreen Database ==
 
-All of the follwing commands should be executed as the postgres user, so start with:
+=== Installing The Schema From Source ===
+
+All of the following commands should be executed as the postgres user, so start with:
 
 {{{
@@ -168 +170 @@
   || ''' NOTE: ''' the location of the contrib directory will change depending on how you installed postgres.  If you can't find one of the contrib modules listed above, use a find command to locate them ie find / -name pgxml.sql ||
 
+Now run eg_db_config.pl ''' on the machine where Open-ils is installed. '''  These instructions assume a two server install - one for Open-ils and Opensrf and one for postgres.  eg_db_config.pl is found on the Open-ils machine.  It will likely be in Open-ILS/src/support-scripts depending on where you installed the Open-ils source.  If you can't find it, run "find" on eg_db_config.pl when you find it run:
 
+{{{
+    perl Open-ILS/src/support-scripts/eg_db_config.pl --create-schema
+}}}
+
+|| ''' NOTE: ''' this script uses opensrf.xml to figure out where the db server is, so it's important to have already configured opensrf to run Evergreen before running this script ||