Changes between Version 19 and Version 20 of sysadminPostgreSQLConfiguration


Ignore:
Timestamp:
Jun 24, 2009, 9:26:09 AM (13 years ago)
Author:
risard
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • sysadminPostgreSQLConfiguration

    v19 v20  
    321321
    322322#now configure postgresql.conf as per the file snippet at the end of these instructions
    323 
    324323#start the database:
    325324   
     
    331330#### CREATE THE EVERGREEN DATABASE ####
    332331
    333 ### from source ###
     332### FROM SOURCE ###
    334333   
    335334    su postgres
    336335    createuser -P -s evergreen
    337 
    338336    createdb -E UNICODE evergreen
    339337    createlang plperl evergreen
     
    343341    psql -f /usr/share/postgresql/8.3/contrib/tsearch2.sql evergreen
    344342    psql -f /usr/share/postgresql/8.3/contrib/pgxml.sql evergreen
    345 
    346343    perl Open-ILS/src/support-scripts/eg_db_config.pl --create-schema #run on the oils server with oils running
    347344
    348345
    349 ### from a dump file ###
     346### FROM A DUMP FILE ###
    350347
    351348#stop oils
     
    354351    su postgres
    355352    psql# drop database evergreen;
    356 
    357 #check if evergreen user is still there
    358     psql# \du
    359 
    360 #if not, create it:
    361 
    362353    createuser -P -s evergreen
    363 
    364 #create db
    365        
    366354    createdb -E UNICODE evergreen
    367355
    368356#edit postgresql.conf checkpoint_segments (see file snippet)
    369 
    370357#start the restore
    371358
     
    378365    ANALYZE
    379366
     367
    380368#### INSTALL JSON::XS ####
    381369
     
    386374    apt-get update
    387375    apt-get install gcc
    388 
    389376    perl -MCPAN -e 'CPAN::Shell?install(“JSON::XS”)'
    390377