| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Chad R(dot) Larson" <chad(at)eldocomp(dot)com> |
| Cc: | Peter Eisentraut <peter_e(at)gmx(dot)net>, Giles Constant <gilesc(at)hyperlink-interactive(dot)co(dot)uk>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Mirroring with WAL? |
| Date: | 2001-10-18 18:24:31 |
| Message-ID: | 24939.1003429471@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Chad R. Larson" <chad(at)eldocomp(dot)com> writes:
> At 10:35 PM 10/17/01 +0200, Peter Eisentraut wrote:
>> There are no plans to make WAL into a replication facility, for reasons
>> which were discussed on the developer lists as well.
> But we =are= still planning to use the WAL to implement a point-in-time
> recovery process, yes?
In its present form it's far too bulky to be kept around over any long
period of time --- or didn't you notice all the squawks about WAL files
overrunning disk as soon as anyone had a long-running transaction?
I'd say it's quite useless for PIT recovery unless we implement some
sort of filtering/compression process to produce an archivable WAL.
Which is doable, certainly, but it's not in the present implementation.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brett Schwarz | 2001-10-18 18:30:23 | Re: Doing a regexp-based search/replace? |
| Previous Message | Brett W. McCoy | 2001-10-18 18:24:07 | Re: "Can't Find any tables, sequences or indexes!" Message |