SF.net SVN: ledger-smb:[2565] trunk/install-mycompany.sh

[..hidden..]

Revision: 2565
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2565&view=rev
Author:   jfkw
Date:     2009-04-17 21:08:59 +0000 (Fri, 17 Apr 2009)

Log Message:
-----------
Install contrib functions per database in WIP install-mycompany.sh.

Modified Paths:
--------------
    trunk/install-mycompany.sh

Modified: trunk/install-mycompany.sh
===================================================================
--- trunk/install-mycompany.sh	2009-04-17 04:19:56 UTC (rev 2564)
+++ trunk/install-mycompany.sh	2009-04-17 21:08:59 UTC (rev 2565)
@@ -2,6 +2,9 @@
 
 CWD=`pwd`
 
+# The following path can vary per distribution
+CONTRIB=/usr/share/postgresql-8.3/contrib
+
 echo 'This script will create a mycompany dataset per INSTALL. Ctrl-C to cancel.'
 
 dropdb -i -U postgres mycompany ; 
@@ -9,8 +12,9 @@
 dropuser -U postgres myuser ; 
 createdb -U postgres -O ledgersmb mycompany ; 
 createlang plpgsql mycompany ; 
-#TODO:  Intall pgsql contrib scripts from a variable path:  tablefunc, pg_trgm, 
-#       tsearch2
+psql -U postgres -d mycompany -f $CONTRIB/tsearch2.sql
+psql -U postgres -d mycompany -f $CONTRIB/tablefunc.sql
+psql -U postgres -d mycompany -f $CONTRIB/pg_trgm.sql
 psql -U postgres -d mycompany -f $CWD/sql/Pg-database.sql ;
 psql -U postgres -d mycompany -f $CWD/sql/modules/Drafts.sql ; 
 psql -U postgres -d mycompany -f $CWD/sql/modules/chart.sql ; 


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.