"Barna, Gary" <Gary(dot)Barna(at)storagenetworks(dot)com> writes:
> bash-2.03$ pg_restore -c -a -d [dbname] ../data/backups/[-Fc Archive]
> pg_restore: [archiver (db)] error returned by PQputline
Lessee ... you drop all the tables (-c) and then try to restore data
without recreating them (-a) ... not too surprising it doesn't work.
I agree the error message sucks though.
FWIW, CVS tip seems to be bright enough to ignore -c when used in
combination with -a; also it gives a more useful message when there
is a failure during a COPY command.
regards, tom lane