Re: [GENERAL] TOC errors

2013-08-02 Thread Jerry Sievers
Perry Smith writes: > I am doing a restore: > > pg_restore --no-owner -L /tmp/db.list --single-transaction > --dbname=condor3_production $DBFILE > > and I get this error: > > pg_restore: [archiver (db)] Error while PROCESSING TOC: > pg_restore: [archiver (db)] Error from TOC entry 2056; 0 35202

Re: [GENERAL] TOC errors

2013-08-02 Thread Alvaro Herrera
Perry Smith escribió: > On Aug 2, 2013, at 12:29 PM, Perry Smith wrote: > > I've used the custom format. The error tells me a line number but I > > can't look at it. Is there a way that I can convert the custom > > format to something I can view? Sure, pg_restore can save its output to a file

Re: [GENERAL] TOC errors

2013-08-02 Thread Perry Smith
On Aug 2, 2013, at 12:29 PM, Perry Smith wrote: > I am doing a restore: > > pg_restore --no-owner -L /tmp/db.list --single-transaction > --dbname=condor3_production $DBFILE > > and I get this error: > > pg_restore: [archiver (db)] Error while PROCESSING TOC: > pg_restore: [archiver (db)] Err

[GENERAL] TOC errors

2013-08-02 Thread Perry Smith
I am doing a restore: pg_restore --no-owner -L /tmp/db.list --single-transaction --dbname=condor3_production $DBFILE and I get this error: pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 2056; 0 35202 TABLE DATA adv_ptf_release_maps pedz