If your trying to do a backup of a production instance using pg_dump and setting up a test instance of that system to do the upgrade against, then your steps are correct. You don't want to run 'database_schema_14-15.sql' against the existing production machine as you will break that installation by doing so.
You need to get a dump of the psql output to us to be able to evaluate what is going wrong. Mark On Jan 19, 2009, at 2:16 AM, Claudia Jürgen wrote: > Hi Rod, > > apart from detail problem. It is best to do the move to another > maching > and the upgrade in 2 seperate steps. Otherwise it is difficult to find > out where precisely the problem lies, if one occurs. > > Sunny Greetings > > Claudia Jürgen > > > Rod Harris schrieb: >> 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 ~~~~~~~~~~~~~ Mark R. Diggory http://purl.org/net/mdiggory/homepage ------------------------------------------------------------------------------ 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
