Am 10.12.18 um 11:15 schrieb Olga Vingurt:
After playing with the dump and importing schema first and data next without the triggers we indeed see that data is missing in the table i.e. dump is not consistent. We don't stop the application which uses database during the dump but according to the documentation the dump still should be consistent.
please check if the data are consistent on the source database system.
How is it possible that pg_dump created dump which is not consistent? Did it happen because we haven't stopped the application?
No, but maybe you have corrupted indexes on the source system. Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company. www.2ndQuadrant.com
