Changes between Version 12 and Version 13 of sysadminPostgreSQLConfiguration


Ignore:
Timestamp:
Jun 23, 2009, 6:40:21 PM (13 years ago)
Author:
risard
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • sysadminPostgreSQLConfiguration

    v12 v13  
    180180You should now have a clean install of the Evergreen schema loaded with the "example consortium."
    181181
     182  || ''' 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 ||
     183
     184
    182185=== Restoring From A Dump File ===
    183186
     
    233236This is necessary to prevent errors during the restore due to the huge side of the database.
    234237
    235 Finally, run:
     238To start the restore, run:
    236239
    237240{{{
     
    241244  || ''' NOTE: ''' It's important not to run eg_db_config.pl if you use the -d option.  This seems to cause conflicts during restore ||
    242245
     246Finally, after the restore is finished (which will take 6 - 8 hours likely) run, as postgres:
     247
     248{{{
     249    VACUUM
     250    ANALYZE
     251}}}
     252
     253Test that everything is there by running a few queries.
     254
     255  || ''' 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 ||
    243256
    244257----
    245258== Connecting the Database Server To The Rest Of Evergreen ==
    246259
    247 After getting the server up and running.
     260Again, 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.
     261
     262To 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.
     263
     264Make sure you've got a compiler installed first:
     265
     266{{{
     267    which gcc
     268}}}
     269
     270If you don't, install one:
     271
     272{{{
     273    apt-get update
     274    apt-get install gcc
     275}}}
     276
     277Next install the mod from CPAN:
     278
     279{{{
     280    perl -MCPAN -e 'CPAN::Shell→install(“JSON::XS”)'
     281}}}
     282
     283Accept the defaults.