Re: binary vs. txt dumps with pg

Hi Tom

> 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.

Hmmm you're right, they are the same now. I don't know what I did this
week, but I was pretty sure the files were different.
Nevermind then, as this saves time and effort.

> There's a timestamp in the custom format file header.

Ah OK that explains the different sums.
Would it be an idea to make it a (default) configuration option for
pg_dump to include a timestamp?

You could work around it by disgarding the first X bytes when
checksumming. Any idea what X would be?

Best regards,

--
   *    ***     Dick Visser         TIENHUIS Networking
  **   *   *    Touwbaan 68             P: +31206843731
   *   * ***    1018 HS Amsterdam       F: +31208641420
   *   * * *    The Netherlands         M: +31622698108
   *   **  *    IP-phone (SIP)/email:  dick@tienhuis.nl
   *   *   *    PGP-key: http://www.tienhuis.nl/gpg.txt
   *   *   *    Webcam: http://www.tienhuis.nl/cam2.asx
  ***   ***