Details
-
Bug
-
Resolution: Fixed
-
Minor
-
5.2.2, 5.3, 5.3.1
-
None
-
None
Description
It seems that the scripts bundled with NAS release 5.2.2 release in scripts/sql/createHarvestDB.pgsql
have errors.
cf. https://sbforge.org/display/NASDOC52/Choose+an+Installation+Scenario#ChooseanInstallationScenario-PostgreSQLDatabase
The 'harvestdefinitions' table created has the wrong schemaversion '4'
Also the harvestchannel lacks a 'issnapshot' field
A workaround for this is the following
drop table harvestchannel; delete from schemaversions where tablename='harvestchannel'; update schemaversions set version='3' where tablename='harvestdefinitions'; \q
The run update_external_harvest_database.sh again
Attachments
Issue Links
- related to
-
NAS-2681 Improve the Postgresql documentation
- Resolved