Skip site navigation (1) Skip section navigation (2)

Re: binary vs. txt dumps with pg

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 (view raw or flat)
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

In response to

Responses

pgsql-admin by date

Next:From: Dick VisserDate: 2005-12-17 18:32:24
Subject: Re: binary vs. txt dumps with pg
Previous:From: olive MckenzieDate: 2005-12-17 14:39:59
Subject: psql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group