I'm trying to restore a database dumped with pg_dump with the -o -Fc options with pg_restore from a 7.1.3 database into a 7.1.3 database on another machine.
When using the -d option in pg_restore, I get this error: Connecting to database for restore Creating <Init> Max OID Archiver(db): Could not execute query. No result from backend. If I don't use -d and pipe the output of pg_restore into psql, I can restore the database, but it takes about 20 hours to restore a .2.8gb dump when uncompressed. So my question is: what is the syntax to restore this dump? Regards, Trevor Astrope [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
