Changes between Version 12 and Version 13 of sysadminPostgreSQLConfiguration

Timestamp:

Jun 23, 2009, 6:40:21 PM (14 years ago)

Author:

risard

Comment:

--

sysadminPostgreSQLConfiguration

@@ -180 +180 @@
 You should now have a clean install of the Evergreen schema loaded with the "example consortium."
 
+  || ''' NOTE: ''' after making any changes to the database or schema, you should run autogen.sh on the oils server to update opac and Staff Client files.  Do this on the oils server as the opensrf user with oils up and running ||
+
+
 === Restoring From A Dump File ===
 
@@ -233 +236 @@
 This is necessary to prevent errors during the restore due to the huge side of the database.
 
-Finally, run:
+To start the restore, run:
 
 {{{
@@ -241 +244 @@
   || ''' NOTE: ''' It's important not to run eg_db_config.pl if you use the -d option.  This seems to cause conflicts during restore ||
 
+Finally, after the restore is finished (which will take 6 - 8 hours likely) run, as postgres:
+
+{{{
+    VACUUM
+    ANALYZE
+}}}
+
+Test that everything is there by running a few queries.
+
+  || ''' NOTE: ''' after making any changes to the database or schema, you should run autogen.sh on the oils server to update opac and Staff Client files.  Do this on the oils server as the opensrf user with oils up and running ||
 
 ----
 == Connecting the Database Server To The Rest Of Evergreen ==
 
-After getting the server up and running.
+Again, assuming a two server setup with Open-ils on one and postgres on the other, you need to ensure that the database server can actually communicate with the oils server.
+
+To begin with, you need to install the JSON::XS perl module on the database server.  This allows the database server to exchange JSON messages with the oils server.
+
+Make sure you've got a compiler installed first:
+
+{{{
+    which gcc
+}}}
+
+If you don't, install one:
+
+{{{
+    apt-get update
+    apt-get install gcc
+}}}
+
+Next install the mod from CPAN:
+
+{{{
+    perl -MCPAN -e 'CPAN::Shell→install(“JSON::XS”)'
+}}}
+
+Accept the defaults.