Changes between Version 10 and Version 11 of NetDRMSInPostgres9

Timestamp:

08/13/14 11:46:07 (10 years ago)

Author:

jennifer

Comment:

--

NetDRMSInPostgres9

@@ -6 +6 @@
 If you're reading this and have decided to go forward with your 9.x compile, changes required are minimal.  The author of this wiki page has only compiled as far as Postgres 9.2 and NetDRMS 7.  It is possible that further changes could be necessary for versions > 9.2 and your situation may be different.  However, for a NetDRMS 7 compilation against Postgres 9.2, you will need to:  
 
-* **Backup**
-If you are doing this on the primary data server, first slap your own hand and then go work on a test bed machine.  If that is unavailable, then do a full backup of your production database, and be certain you've configured Postgres 9 to run on two different ports (one for the drms database and another for the sums database).  Make doubly sure that all your usual keyboard shortcuts and aliases are re-worked (perhaps in a new .profile or .login file) to reference the new database compiling environment.  Better safe than sorry.  
+* **Backup and Migration**
+If you are doing this on the primary data server, first slap your own hand and then go work on a test bed machine.  If that is unavailable, then do a full backup of your production database, and be certain you've configured Postgres 9 to run on two different ports (one for the drms database and another for the sums database).  Make doubly sure that all your usual keyboard shortcuts and aliases are re-worked (perhaps in a new .profile or .login file) to reference the new database compiling environment.  If you are upgrading from an 8.4.x database, recall that you are undergoing a major version change and that involves "data migration".  You may find that the migration tool provided by Postgres is unsuccessful.  If so, you may need to migrate your data using a plain-text format data dump (with SQL "insert" commands). Check the Postgres website for migration options and do some testing before assuming the 9.2.x database is fully ready.  Better safe than sorry.  
 
 * **Change one line in two places in the SUMS code** 
 
+Once your database is correctly populated and backed up, you can look at the NetDRMS code.  
 Change two files in base/sums/libs/pg    named SUMLIB_RmDo.pgc and SUMLIB_RmDoX.pgc  and make this modification to line 9
 {{{
@@ -24 +25 @@
 You may need to make changes to local environment variables if you have an existing Postgres 8.4.x installed on the machine.  
 
-If you already have a prior version of Postgres installed and want to compile NetDRMS against v. 9.x instead, set your $PATH and $LD_LIBRARY_PATH variables properly to reflect the Postgres 9.2 paths.  You might want to do this a .profile file and source it every time you log in to avoid confusing errata later.  
+If you already have a prior version of Postgres installed and want to compile NetDRMS against v. 9.x instead, set your $PATH and $LD_LIBRARY_PATH variables properly to reflect the Postgres 9.2 paths.  You might want to do this a .profile file and source it every time you log in to avoid confusing errata later.  Make sure you have set these environment variables before proceeding, with appropriate values for your location and machines: 
+{{{
+export JSOC_ROOT=/opt/netdrms7/source
+export JSOC_DBHOST=machinename_localhost  --whatever you're calling your database host in your .pgpass file
+export JSOC_DBNAME=facilityname_drms
+export JSOC_DBUSER=your_user
+export JSOC_MACHINE=linux_x86_64  --assuming you're on that linux platform - yours may be different
+export DRMS_DBPORT=5433  --author's test port number, default is 5432
+export SUMPGPORT=5435    --author's test port number, default is 5434
+export DRMS=$JSOC_ROOT
+export SUMSSERVER=machinename_localhost
+}}}
+
 
 There you go - that's all that is required.