you might want to log any errors resulting from pg_dump and then grep
through them to verify. or you could record the exit status ( $? ) for each
pg_dump command.
I was also thinking about how to check if something malformed your data on
disk. I could think of some ways to do that, but it doesn't
Our database has some corrupt tables and I'm trying to figure out what data
can be salvaged and what needs to be restored from backup or regenerated.
Initially I tried running select count(*) on all user tables. While this
did detect some corrupt tables, it missed others. For example, I was able
t
