Changes between Version 5 and Version 6 of NetDRMSInPostgres9
- Timestamp:
- 08/06/14 12:25:34 (10 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
NetDRMSInPostgres9
v5 v6 4 4 That said, the most compelling reason for not updating Postgres is if you are running Slony replication as an active master. If you are a "Slony master", such as the JSOC at Stanford, then you cannot support Slony 1.x against Postgres 9.2. Stanford's replication processes at this time require Slony 1.2, and Postgres 8.4.x is the last version supported for that particular Slony version. However, if you are only a passive Slony recipient, getting slony files and database changes but never issuing any yourself, then you are not confined to any particular database version. Before making any change you should first have a conversation with your systems administrator and your department about changing their database since they might have rules or scripts that require testing. 5 5 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, the following may be of use.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: 7 7 8 Compiling NetDRMS v.7 against Postgres 9.2 requires changing one line in the SUMS code, and ensuring config.local has the right paths (file located in the top netdrms source directory). It may also require changes to local environment variables if you have an existing Postgres 8.4.x installed on the machine. 9 10 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. Assign corresponding paths to Postgres-specific variables in config.local. 11 12 The change required to the SUMS code is one line in two places. 8 *Change one line in two places in the SUMS code 13 9 14 10 Change two files in base/sums/libs/pg named SUMLIB_RmDo.pgc and SUMLIB_RmDoX.pgc and make this modification to line 9 … … 17 13 EXEC SQL TYPE uint64_t IS unsigned long int; 18 14 }}} 15 16 17 *Ensure config.local has the right paths listed for Postgres-specific variables (config.local file is located in the top netdrms source directory). 18 19 *Possibly make changes to local environment variables if you have an existing Postgres 8.4.x installed on the machine. 20 21 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. 19 22 20 23 There you go - that's all that is required.