Hi, I think you have to load dump files created with the '-Fc' flag with the pg_restore utility.
http://www.postgresql.org/docs/7.4/interactive/app-pgrestore.html -Greg Jeffrey Trimble wrote: > 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 > ------------------------------------------------------------------------- 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
