Rod,
You probably forgot to recreate the db that's why you got the errors,
run before you restore the data (and after you created the empty database):
(from the target directory)
ant setup_database
ant load_registries
now restore your database
*psql -U dspace -d dspace < dspace-backup.sql
*and finally (if all goes well) run the
database_schema_14-15.sql
I hope it helps!
Kostas Paraskevopoulos
Katharine Hepburn - "Death will be a great relief. No more interviews."
On Mon, Jan 19, 2009 at 05:25, Rod Harris <[email protected]> wrote:
> Hi all
>
> I'm still trying to move our dspace 1.4 instance to a separate machine
> running 1.5. All the docs I've found only tell how to upgrade a 1.4 to 1.5
> instance of dspace, not move everything to a new machine altogether and
> upgrade to 1.5 at the same time.
>
> I have done a *pg_dump --oids -U dspace -f dspace-backup.sql dspace*
> from the 1.4 machine
>
> then scp the dspace-backup.sql file to the 1.5 machine.
>
> Then on the 1.5 machine (which had a running vanilla dspace 1.5 install)
>
> *dropdb dspace*
> *createdb -U dspace -E UNICODE dspace*
> *psql -U dspace -d dspace < dspace-backup.sql*
>
> but that fell in a heap - there was something printed to the terminal (that
> went by too fast to catch with ^c and I wasn't able to redirect the output
> to a file either) then a lot of:
> invalid command \N
>
> and occasionally
> syntax error near ...
>
> and finally
>
> Failed
>
>
> Does what I've done actually look at all right or is it the wrong approach
> altogether?
>
> I also know of the 'database_schema_14-15.sql' but do I use it before I try
> to load the 1.4 dump into the 1.5 database or after?
>
> Cheers. Rod
>
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by:
> SourcForge Community
> SourceForge wants to tell your story.
> http://p.sf.net/sfu/sf-spreadtheword
> _______________________________________________
> DSpace-tech mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>
>
------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
