Re: Mirroring with WAL? - Mailing list pgsql-admin

From Giles Constant
Subject Re: Mirroring with WAL?
Date
Msg-id Pine.LNX.4.33.0110190955130.10700-100000@gilecpc.d1.hyperlink-interactive.co.uk
Whole thread Raw
In response to Re: Mirroring with WAL?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
On Thu, 18 Oct 2001, Tom Lane wrote:

> 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?

hm..  How does this compare with the Oracle system?  Are the Oracle logs
smaller?  This is how we perform most of our mirroring with Oracle, and
yes, it does produce rather large files, but once the most recent file has
been transferred over and uploaded into the mirror database, they get
deleted.  Admittedly this involves lots of cron writing, but it works..
:-)

--
Giles Constant, Systems Programmer
Hyperlink Interactive
http://www.hyperlink-interactive.co.uk


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: psql \l problem
Next
From: "Shuzo Kubo"
Date:
Subject: VACUUMing a live site OK?