On Mon, Aug 27, 2012 at 2:16 PM, Nitin Paliwal <nitinpaliwal2...@gmail.com> wrote: >> 1. Take the Backup of Dsapce 1.4.2 on Windows (can I use PG ADMIN for >> that?) >> 2. Restore it on 1.8.2 on Ubuntu.(can i import using PG ADMIN as I have >> installed PG ADMIN on Ubuntu as well and already configured it)
Yes, I think so. Anything that copies over the database in its current form. >> 4. Upgrade the 1.8.2 database using >> [dspace-src]/dspace/etc/postgres/database_schema_14-15.sql >> [dspace-src]/dspace/etc/postgres/database_schema_15-16.sql >> [dspace-src]/dspace/etc/postgres/database_schema_16-17.sql >> [dspace-src]/dspace/etc/postgres/database_schema_17-18.sql There might be a way to do that from PgAdmin, just run the sql files on the "dspace" database as the "dspace" user. Alternatively, use the "psql" client as I originally wrote. So yes, your steps are generally correct, you just chose to use different tools. That should be fine. 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 Dspace-general@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-general
