Changes between Version 19 and Version 20 of sysadminPostgreSQLConfiguration

Timestamp:

Jun 24, 2009, 9:26:09 AM (14 years ago)

Author:

risard

Comment:

--

sysadminPostgreSQLConfiguration

@@ -321 +321 @@
 
 #now configure postgresql.conf as per the file snippet at the end of these instructions
-
 #start the database:
     
@@ -331 +330 @@
 #### CREATE THE EVERGREEN DATABASE #### 
 
-### from source ###
+### FROM SOURCE ###
     
     su postgres
     createuser -P -s evergreen
-
     createdb -E UNICODE evergreen
     createlang plperl evergreen
@@ -343 +341 @@
     psql -f /usr/share/postgresql/8.3/contrib/tsearch2.sql evergreen
     psql -f /usr/share/postgresql/8.3/contrib/pgxml.sql evergreen
-
     perl Open-ILS/src/support-scripts/eg_db_config.pl --create-schema #run on the oils server with oils running
 
 
-### from a dump file ###
+### FROM A DUMP FILE ###
 
 #stop oils
@@ -354 +351 @@
     su postgres
     psql# drop database evergreen;
-
-#check if evergreen user is still there
-    psql# \du
-
-#if not, create it:
-
     createuser -P -s evergreen
-
-#create db
-        
     createdb -E UNICODE evergreen
 
 #edit postgresql.conf checkpoint_segments (see file snippet)
-
 #start the restore
 
@@ -378 +365 @@
     ANALYZE
 
+
 #### INSTALL JSON::XS ####
 
@@ -386 +374 @@
     apt-get update
     apt-get install gcc
-
     perl -MCPAN -e 'CPAN::Shell?install(“JSON::XS”)'