Re: binary vs. txt dumps with pg

Поиск
Список
Период
Сортировка
От Dick Visser
Тема Re: binary vs. txt dumps with pg
Дата
Msg-id 43A459B8.9040800@tienhuis.nl
обсуждение исходный текст
Ответ на Re: binary vs. txt dumps with pg  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: binary vs. txt dumps with pg
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: binary vs. txt dumps with pg
Следующее
От: Chris Browne
Дата:
Сообщение: Re: Please guide me.