To upgrade your 1.4 data model to have all the new tables that exist in 1.6,
you have to upgrade your database.
At a minimum, you have to run the following two commands.
For PostgreSQL
psql -U [dspace-user] -f
[dspace-source]/dspace/etc/postgres/database_schema_14-15.sql
[database-name]
psql -U [dspace-user] -f
[dspace-source]/dspace/etc/postgres/database_schema_15_16.sql [database
name]
--
Peter Dietz
Systems Developer/Engineer
Ohio State University Libraries
On Tue, Sep 28, 2010 at 3:00 PM, liss RR <[email protected]> wrote:
> Hi Peter:
>
> I have installed dspace v. 1.4.2 and 1.6.2 in diferents servers there are
> not in the same machine.
> Must I do that you tell me anyway? or must I do some diferent?
>
> thank you
>
> ------------------------------
> From: [email protected]
> Date: Tue, 28 Sep 2010 13:33:06 -0400
> Subject: Re: [Dspace-tech] restore DB
> To: [email protected]
> CC: [email protected]
>
>
> Hi,
>
> Take a look at the Upgrade Documentation.
>
> http://scm.dspace.org/svn/repo/dspace/trunk/dspace/docs/html/ch04.html#N11293
>
> There's plenty of little tasks you need to do to make the most of each
> upgrade.
>
> In its most basic terms, you'll need to run the database upgrade scripts.
> To move your data from 1.4.2 you have to use the db upgrade script to get
> to 1.5, then do another db upgrade script to get to 1.6
> 1 - 14-15
> 2 - 15-16
>
> --
> Peter Dietz
> Systems Developer/Engineer
> Ohio State University Libraries
>
>
>
> On Tue, Sep 28, 2010 at 1:20 PM, liss RR <[email protected]> wrote:
>
> Hi:
>
> I have a question, It's posible restore the postgresql database of Dspace
> v. 1.4.2 to postgresql database of Dspace v. 1.6.2?
>
> I used this comand:
>
> C:\programfiles\postresql\8.2\bin>pg_restore.exe -i -h localhost -p 5432 -U
> postgres -d dspace -l "C:\Program Files\PostgreSQL\8.2\bin\02032010"
>
> and I copied the assestore dir to the dspace\assestore on my new
> instalation too.
>
> but the repository only shows cominities. the coleccions and registires are
> not showing.
>
> Please can anyone help me? what must I do?
>
> Thanks!!!
>
>
> ------------------------------------------------------------------------------
> Start uncovering the many advantages of virtual appliances
> and start using them to simplify application deployment and
> accelerate your shift to cloud computing.
> http://p.sf.net/sfu/novell-sfdev2dev
> _______________________________________________
> DSpace-tech mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>
>
>
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
