From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Dick Visser <dick(dot)visser(at)tienhuis(dot)nl> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: binary vs. txt dumps with pg |
Date: | 2005-12-17 18:17:32 |
Message-ID: | 8662.1134843452@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Dick Visser <dick(dot)visser(at)tienhuis(dot)nl> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Dick Visser | 2005-12-17 18:32:24 | Re: binary vs. txt dumps with pg |
Previous Message | olive Mckenzie | 2005-12-17 14:39:59 | psql |