pg_restore --data-only (-a) does not work
pg_restore --data-only (-a) does not work
От:
"Barna, Gary" <Gary.Barna@storagenetworks.com>
Дата:
I tried countless ways to try to restore data only for all tables using the -a switch. None seem to work. I was able to restore data only for specific tables using the -t switch, but I was expecting that I should be able to invoke a command with -a that checks all tables and restores all data appropriately. Here's the last thing I tried. bash-2.03$ pg_restore -c -a -d [dbname] ../data/backups/[-Fc Archive] pg_restore: [archiver (db)] error returned by PQputline Any ideas?? Thanks, Gary
Re: pg_restore --data-only (-a) does not work
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
"Barna, Gary" 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