"Barna, Gary" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings