On Jan 23, 2008, at 11:53 PM, Steve Thomas wrote: > Yup, sorry -- should have included that. > > Dump was done using: > > /usr/local/pgsql/bin/pg_dump \ > --verbose \ > --oids \ > --create \ > --format=c \ > --username=dspace \ > dspace > dumpfile
You might try dumping to a file explicitly ( -f dumpfile ) > > pg_restore -C -d postgres -U dspace dumpfile > > but when I include "-d postgres" I get this error: I think you want to connect to the dspace database ( -d dspace ) > > > pg_restore: [archiver (db)] connection to database "postgres" > failed: FATAL: database "postgres" does not exist > > which is possibly a vital clue. Leaving out the "-d postgres" > option, it seems to work -- outputs lots of CREATE TABLE messages > etc. -- but ... results as below. > > Am I supposed to create a database named "postgres" after initdb? No >>> >>> createuser -U postgres -d -A -P dspace ; createdb -U dspace -E >>> UNICODE dspace I usually use UTF8, I'm not sure if UNICODE is valid or not. >>> -Mark ~~~~~~~~~~~~~ Mark R. Diggory - DSpace Systems Manager MIT Libraries, Systems and Technology Services Massachusetts Institute of Technology ------------------------------------------------------------------------- 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