I'm attempting to revisit this nasty process. I'm testing again to see if I can ever get this to work to have a suitable way for a migration path for new versions of Postgresql. I was able to backup my data using:
pg_dump -Fc dspace > /dspace/backup Then I recreated the database, per Postgresql's instruction for a new database (as if it was a new installation) Then following the instructions: psql dspace < /dspace/backup I get the following errors: ERROR: syntax error at or near "PGDMP" at character 1 ERROR: syntax error at or near "AS" at character 5 ERROR: syntax error at or near "" at character 1 ERROR: syntax error at or near "" at character 1 <---Ad nausem Then garbage characters. Facts regarding this procedure: User logged in as "Dspace" (My assumption is user Dspace is able to perform the backup) Postgres version: 7.4.6 for testing. Any postgres guru's out there that want to give me a hand in this? I would really like to master this, since snapshots, while good, do not let you have a migration path. TIA, Jeffrey A. Trimble Systems Librarian Youngstown State University Youngstown, OH [EMAIL PROTECTED] (330) 941-2483 http://digital.maag.ysu.edu http://www.maag.ysu.edu http://jupiter.ysu.edu ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
