| From: | Dick Visser <dick(dot)visser(at)tienhuis(dot)nl> |
|---|---|
| To: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: binary vs. txt dumps with pg |
| Date: | 2005-12-20 08:38:41 |
| Message-ID: | 43A7C311.3020404@tienhuis.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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 is that our backups are made with rsnapshot.
This means that if files have changed, a complete copy of the file is
backupped....
--
* *** Dick Visser TIENHUIS Networking
** * * Touwbaan 68 P: +31206843731
* * *** 1018 HS Amsterdam F: +31208641420
* * * * The Netherlands M: +31622698108
* ** * IP-phone (SIP)/email: dick(at)tienhuis(dot)nl
* * * PGP-key: http://www.tienhuis.nl/gpg.txt
* * * Webcam: http://www.tienhuis.nl/cam2.asx
*** ***
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Boguk Maxim | 2005-12-20 09:16:18 | Some strange issues with VACUUM on one table. |
| Previous Message | Tom Lane | 2005-12-20 02:51:43 | Re: PG8.1 - Config file check |