From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Albe Laurenz <all(at)adv(dot)magwien(dot)gv(dot)at> |
Cc: | "Tim Allen *EXTERN*" <tim(at)proximity(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org, Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-patches(at)postgresql(dot)org |
Subject: | Re: Forcing current WAL file to be archived |
Date: | 2006-08-01 11:49:32 |
Message-ID: | 200608011149.k71BnWq22892@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Albe Laurenz wrote:
> Tim Allen wrote:
> >>>Patch included to implement xlog switching, using an xlog record
> >>>"processing instruction" and forcibly moving xlog pointers.
> >>>
> >>>1. Happens automatically on pg_stop_backup()
> >>
> >>
> >> Oh - so it will not be possible to do an online backup
> >> _without_ forcing a WAL switch any more?
> >
> > Well, previously, you would have always had to simulate a wal
> > switch, by
> > working out which is the current wal file and copying that. Otherwise
> > your online backup wouldn't be complete.
> >
> > What Simon is describing sounds like a big step forward from that
> > situation. It should let me delete half the code in my pitr
> > backup/failover scripts. Definitely a Good Thing.
>
> Certainly a Good Thing, and it should be on by default.
>
> But couldn't there be situations where you'd like to do an
> online backup without a WAL switch? To avoid generating an
> archive WAL every day on a database with few changes, e.g.?
>
> Maybe not, I'm just wondering.
Considering the I/O caused by the backup, a new WAL file seems
insignificant, and until a log switch, the backup isn't useful.
--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2006-08-01 11:50:22 | Re: [HACKERS] float8 regression failure (HEAD, cygwin) |
Previous Message | Bruce Momjian | 2006-08-01 11:43:09 | Re: Online index builds |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2006-08-01 11:50:22 | Re: [HACKERS] float8 regression failure (HEAD, cygwin) |
Previous Message | Adrian Maier | 2006-08-01 11:30:07 | Re: [HACKERS] float8 regression failure (HEAD, cygwin) |