Re: [ADMIN] binary vs. txt dumps with pg

2005-12-20 Thread Dick Visser
Jim C. Nasby wrote: I believe that by default the custom format is gzip'd, which also means you probably couldn't exclude just the timestamp. Though if you're using rsync, I think there's a good chance it would only tranfer the first few hundred KB... Yes that is true. What I forgot to mention

Re: [ADMIN] binary vs. txt dumps with pg

2005-12-19 Thread Jim C. Nasby
On Sat, Dec 17, 2005 at 07:32:24PM +0100, Dick Visser wrote: > You could work around it by disgarding the first X bytes when > checksumming. Any idea what X would be? I believe that by default the custom format is gzip'd, which also means you probably couldn't exclude just the timestamp. Though i

Re: [ADMIN] binary vs. txt dumps with pg

2005-12-17 Thread Dick Visser
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 wa

Re: [ADMIN] binary vs. txt dumps with pg

2005-12-17 Thread Tom Lane
Dick Visser <[EMAIL PROTECTED]> 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 s

[ADMIN] binary vs. txt dumps with pg

2005-12-17 Thread Dick Visser
Hi all This is my first post to the pgsal-admin list. I am doing IT support for a small company, and we have been running PG for a few years now. I have recently upgraded our PG-8.0.3 server to 8.1.0. Everything went OK, and now I am working on the backup schema. I seems that since 8.1 pg_dump