Well, this ran fine...but the database is empty and so is the table. I'm going to run it again and see if I can get the verbose output of my results.
I am making progress. TIA, --jat At 02:29 PM 5/29/2007, Greg McClellan wrote: >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 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
