Re: [Dspace-tech] psql restoring a dump

2007-05-29 Thread Jeffrey Trimble
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

Re: [Dspace-tech] psql restoring a dump

2007-05-29 Thread Mark H. Wood
On Tue, May 29, 2007 at 02:06:04PM -0400, 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_

Re: [Dspace-tech] psql restoring a dump

2007-05-29 Thread Greg McClellan
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

[Dspace-tech] psql restoring a dump

2007-05-29 Thread Jeffrey Trimble
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 Postgres