Steve, can you post the pg_dump command and options you've used?
-Mark On Jan 23, 2008, at 9:08 PM, Steve Thomas wrote: > I need help! I'm using pg_dump to make a backup of our database, > and ... > sensibly, I think ... wanted to confirm that we could restore from > this > dump using pg_restore. > > (Actually, I've done this once without drama, when migrating from our > dev server to our production server.) > > So, on our dev server, I followed the instructions for pg_restore, but > cannot get it to work (and thus now have no dev database!) > > I've gone right back to square one and reinstalled postgresql. Then: > > * ran initdb -- no problem > > * ran > > createuser -U postgres -d -A -P dspace ; createdb -U dspace -E > UNICODE dspace > > as per instructions -- no problem. > > * ran pg_restore to restore data: > > pg_restore -C -U dspace 200712061830 > > This seemed to run OK, creating all the tables and adding data, > but ... > > * if I run > > $ psql dspace dspace > > I get > > dspace=> select * from item; > ERROR: relation "item" does not exist > > -- ie apparently there's no data. > > > So, can anyone help with where I'm going wrong? Right now I have no > dev server so I'm in deep ... > > > Thanks, > Steve > > -- > > Stephen Thomas, > Senior Systems Analyst, > University of Adelaide Library > UNIVERSITY OF ADELAIDE SA 5005 AUSTRALIA > Phone: +61 8 830 35190 > Fax: +61 8 830 34369 > Email: [EMAIL PROTECTED] > URL: http://www.adelaide.edu.au/directory/stephen.thomas > CRICOS Provider Number 00123M > > ----------------------------------------------------------- > This email message is intended only for the addressee(s) and > contains information that may be confidential and/or copyright. If > you are not the intended recipient please notify the sender by reply > email and immediately delete this email. Use, disclosure or > reproduction of this email by anyone other than the intended > recipient(s) is strictly prohibited. No representation is made that > this email or any attachments are free of viruses. Virus scanning is > recommended and is the responsibility of the recipient. > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech