Re: binary vs. txt dumps with pg - Mailing list pgsql-admin

From Dick Visser
Subject Re: binary vs. txt dumps with pg
Date
Msg-id 43A459B8.9040800@tienhuis.nl
Whole thread Raw
In response to Re: binary vs. txt dumps with pg  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: binary vs. txt dumps with pg  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-admin
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
  ***   ***

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: binary vs. txt dumps with pg
Next
From: Chris Browne
Date:
Subject: Re: Please guide me.