Changes between Version 6 and Version 7 of sysadminPostgreSQLConfiguration

Timestamp:

Jun 23, 2009, 5:46:24 PM (14 years ago)

Author:

risard

Comment:

--

sysadminPostgreSQLConfiguration

@@ -59 +59 @@
 Postgres uses the term "database cluster" to describe the directory it uses to store data.  During the apt install, a default directory is created, usually at: /var/lib/postgresql/8.3/main. 
 
-  '''NOTE: ''' our servers have been partitioned to best serve the needs of Evergreen.  The default location is not usually on a partition that has been sized appropriately for the Evergreen db.  Generally, you will ''' not ''' be using the default install directory for your database cluster. 
+ || '''NOTE: ''' our servers have been partitioned to best serve the needs of Evergreen.  The default location is not usually on a partition that has been sized appropriately for the Evergreen db.  Generally, you will ''' not ''' be using the default install directory for your database cluster. ||
 
 You will need to determine the appropriate partition to install the cluster on.  Usually, this is /data.  To be sure, you can use the disk free command to see:
@@ -83 +83 @@
 
 Looking at the above, clearly the /data patition is the largest (84G) compared to the others.  
-   ''' NOTE: ''' Having located the largest partition, you will need to create directory for the data cluster, and give the postgres user full access to it.  In the spirit of keeping things standardized, we have been using the /postgresql/<version>/main format.
+ 
+  ||''' NOTE: ''' Having located the largest partition, you will need to create directory for the data cluster, and give the postgres user full access to it.  In the spirit of keeping things standardized, we have been using the /postgresql/<version>/main format. ||
 
 {{{
@@ -141 +142 @@
 == Installing the Evergreen Schema ==
 
+All of the follwing commands should be executed as the postgres user, so start with:
+
+{{{
+    su postgres
+}}}
+
+First you need to create a new db user which can be used to run manage the Evergreen database:
+
+{{{
+    createuser -P -s evergreen
+}}}
+
+Next, you need to: 1) create the db, 2) add a few programming languages used by Evergreen and 3) add some contributed modules to postgresql that provide extra functionality used by Evergreen like the ability to do cross-tab queries and full text searching.
+
+{{{
+    createdb -E UNICODE evergreen
+    createlang plperl evergreen
+    createlang plperlu evergreen
+    createlang plpgsql evergreen
+    psql -f /usr/share/postgresql/8.3/contrib/tablefunc.sql evergreen
+    psql -f /usr/share/postgresql/8.3/contrib/tsearch2.sql evergreen
+    psql -f /usr/share/postgresql/8.3/contrib/pgxml.sql evergreen
+}}}
+
+  || ''' 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 ||
+