Dick Visser <dick.visser@xxxxxxxxxxx> writes: > Since I use rysnc to a remote host for backups, I have created a > script hat dumps each db to a file, and then checks if the dump from > yesterday is different. > I have been fiddling with all kinds of techniques to accomplish this. > The only way that seems to work is to make txt based dumps, and strip > out all the comments and empty lines: Have you retested this assumption recently? We got rid of the OIDs and stuff in the default comments, so I think that you should be able to just diff the text dump files without any weird processing. > When I try to dump to custom format, the dumps are *not* the same > anymore, even though the data has *not* changed. There's a timestamp in the custom format file header. regards, tom lane
