Thanks everyone for your help
I think the problem came from this version incompatibility: our dspace
1.4 was running postgres 7.3 and our dspace 1.5 is using postgres 8.1
the way I gout around it in the end was to use this command to dump the
pg database from 1.4.x
pg_dump -C -d -f dspace-backup.sql dspace
the -d flag causes this: dump data as INSERT, rather than
COPY, commands
I'm not really sure exactly what that means but it seems to have worked
so far...
Thanks again.
Rod
Thornton, Susan M. (LARC-B702)[NCI INFORMATION SYSTEMS] wrote:
I’ve had
some problems in the past
with this too. Here is how I backup and restore (I don’t use
pgAdminIII
to do it):
Backup: pg_dumpall >
dspace.out
Restore:
/usr/local/pgsql/bin/psql
-d template1 -f dspace.out
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
