On Mon, Aug 27, 2012 at 1:40 PM, Nitin Paliwal <[email protected]> wrote: > In 4th step > > a) I have to run upgrades scripts database_schema_14-15.sql through > database_schema_17-18.sql on the pg_dumpsql file. (Kindly let me know the > command to run upgrade scripts.)
Use the postgres command-line client. In the [dspace-src]/dspace/etc/postgres/ directory, run: psql /path/to/your_export_from_dspace_1.4.sql psql database_schema_14-15.sql psql database_schema_15-16.sql psql database_schema_17-18.sql > OR b) I have to run upgrades scripts on dspace 1.4 on windows. > > OR c) I have to run upgrades scripts on dspace 1.8 on ubuntu after importing > the pg_dump data. You'll run it on Ubuntu after importing the database in 1.4 format. > In 5th step I have to import the SQL file. > > a ) is it the same file that is created in step 4 (a) My mistake, I had steps 4 and 5 reversed. See the psql commands above for the correct procedure. > OR b) I have to export the data after running upgrades scripts on dspace 1.4 > on windows and import it in dspace 1.8 No, don't do that. That would change your original database format on the 1.4 machine and you'd have to use a backup if anything went wrong. Regards, ~~helix84 ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Dspace-general mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-general
