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
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
So my question is: what is the syntax to restore this dump?
pgsql-admin by date
|Next:||From: Denis Chavez||Date: 2002-02-25 17:20:43|
|Subject: About RBAC in postgres|
|Previous:||From: Bruno Wolff III||Date: 2002-02-25 15:28:48|
|Subject: Re: Reset sequence number|