pg_restore toc error


        
            
                Markdown 0.54 KB
                                    
                        | None                    
                
                                        |
    0    0                            

            
                
                                    raw
                    download
                    clone
                    embed
                    print
                
                                    report
                
                
                            
        
        
            pg_restore: [archiver (db)] Error from TOC entry 4965; 0 138871 TABLE DATA ir_act_report_xml insigni
Solution1: this did the trick
pg_dump database_name -c -Ft -f file_name.tar 
pg_restore -d database_name -c file_name.tar
before this i was trying to restore with out including -c (clean)

even though -c is included in pg_dump it is not used in pg_restore unless we say to use...
Solution 2: 
pg_restore --verbose --clean --no-acl --no-owner -h localhost -U username -d database_name dump_name.dump