<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">
John,<div><br></div><div>Please follow the upgrade instructions supplied for upgrading DSpace 1.4.2 to 1.5 (page 50). The upgrade process described in the documentation will take you through the appropriate steps to convert the DSpace postgres database from 1.4.2 to 1.5 </div><div><br></div><div><a href="http://www.dspace.org/images/onepointfivedocs/dspacemanual_15_may.zip">http://www.dspace.org/images/onepointfivedocs/dspacemanual_15_may.zip</a></div><div><br></div><div><div><div>On Aug 1, 2008, at 11:45 AM, John Furfey wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"> We're in the process of upgrading from 1.4.2 to 1.5, and we're also moving to a new server.<div><br></div><div>We've got 1.5 up and running and we're trying to figure out the best way of migrating our data. Is it possible to do a pg_dump from the 1.4.2 server and do a pg_restore on the 1.5 server? Or will 1.5's new db schema prevent this?</div></blockquote><div><br></div>You do not want to attempt to do it in this order. The upgrade process supplies a SQL script (<span class="Apple-style-span" style="font-family: Verdana; font-size: 10px; ">database_schema_14-15.sql) <span class="Apple-style-span" style="font-family: Helvetica; font-size: 12px; ">to make the necessary changes to your existing database to upgrade from 1.4.2 to 1.5, you do not need to do a fresh install of an empty DSpace instance and migrate your data into it. I also highly recommend using dp_dump/psql to create a copy of your database and install a replica of your dspace installation on another machine to properly "test" that the upgrade process will work successfully for your product server before attempting it there. This will also give you an opportunity to become familiar with the upgrade process before doing it against a mission critical instance.</span></span></div><div><br></div><div>To backup a postgres database instance on linux the we use the following command/options</div><div><br></div><div><blockquote type="cite" class=""><span class="Apple-style-span" style="color: rgb(0, 0, 0); ">pg_dump --oids -U dspace -f dspace-backup.sql [dspace-db-name]</span></blockquote></div><div><br></div><div>Where [dspace-db-name] is the name of your dspace database in the postgres cluster (usually this is "dspace" by default). To restore the backup to the same location, </div><div><br></div><div><blockquote type="cite" class=""><span class="Apple-style-span" style="color: rgb(0, 0, 0); ">psql -U dspace -d [dspace-db-name] < <span class="Apple-style-span" style="color: rgb(0, 0, 221); -webkit-text-stroke-width: -1; ">dspace-backup.sql</span></span></blockquote></div><div><br></div><div>or to the same name on another machine where you do not already have the database or dspace user created, you would do.</div><div><br></div><div><div><div><blockquote type="cite" class=""><div><div>createuser -U postgres -d -A -P dspace </div></div><div><div>createdb -U dspace -E UNICODE <span class="Apple-style-span" style="-webkit-text-stroke-width: -1; ">[dspace-db-name]</span></div></div></blockquote></div></div><div><div><blockquote type="cite" class="">psql -U dspace -d <span class="Apple-style-span" style="-webkit-text-stroke-width: -1; ">[dspace-db-name]</span> < dspace-backup.sql</blockquote></div></div></div><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font class="Apple-style-span" face="Verdana" size="2"><span class="Apple-style-span" style="font-size: 10px;"><br></span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font class="Apple-style-span" face="Verdana" size="2"><span class="Apple-style-span" style="font-size: 10px;"><br></span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font class="Apple-style-span" face="Verdana" size="2"><span class="Apple-style-span" style="font-size: 10px;"><span class="Apple-style-span" style="font-family: Helvetica; font-size: 12px; "><div><blockquote type="cite"><div>Thanks for any response, I have not been able to find any documentation for this scenario.</div></blockquote><br></div><div>Certainly do feel free to post any questions about how to handle your upgrade properly with the dspace-tech list. We in the community who have worked on creating this upgrade process would like to assure your switch to 1.5.0 is a success.</div><div><br></div></span></span></font></div></div><div>-Mark</div><div><br></div></div><div> <span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; -webkit-text-decorations-in-effect: none; text-indent: 0px; -webkit-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; -webkit-text-decorations-in-effect: none; text-indent: 0px; -webkit-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><span class="Apple-style-span" style="border-collapse: separate; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; -webkit-text-decorations-in-effect: none; text-indent: 0px; -webkit-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><span class="Apple-style-span" style="border-collapse: separate; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; -webkit-text-decorations-in-effect: none; text-indent: 0px; -webkit-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><div>~~~~~~~~~~~~~</div><div>Mark R. Diggory - DSpace Developer and Systems Manager</div><div>MIT Libraries, Systems and Technology Services</div><div>Massachusetts Institute of Technology</div><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Home Page: <a href="http://purl.org/net/mdiggory/homepage">http://purl.org/net/mdiggory/homepage</a></div></div><div><br class="khtml-block-placeholder"></div><br class="Apple-interchange-newline"></span></span></span></div></span></div></span><br class="Apple-interchange-newline"></span><br class="Apple-interchange-newline"></span></span></span> </div><br></body></html>