Re: Backing up the currently used wal segment

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: "Florian G(dot) Pflug" <fgp(at)phlo(dot)org>
Cc: Postgresql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Backing up the currently used wal segment
Date: 2006-07-06 18:04:25
Message-ID: 20060706180425.GU22057@kenobi.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* Florian G. Pflug (fgp(at)phlo(dot)org) wrote:
> I'd like to implement that scheme, but am unsure how
> to determine that segment reliably. I noticed that
> there is an pg_xlog/archive_status directory, which
> contains *.done files for some of the archived wal logs.

Personally, I was just lazy and rsync the whole dir off to a seperate
area on the backup server every 5 minutes. :)

Enjoy,

Stephen

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brennan, Sean (IMS) 2006-07-06 18:06:46 Delete cascade and trigger permissions?
Previous Message Richard Broersma Jr 2006-07-06 18:02:15 Re: How to hide NOTICE messages in psql.exe ?