Re: [HACKERS] Forcing wal rotation

2006-07-27 Thread Simon Riggs
On Sun, 2006-07-16 at 01:04 +0300, Hannu Krosing wrote: > Ühel kenal päeval, R, 2006-07-14 kell 17:39, kirjutas Simon Riggs: > > On Fri, 2006-07-14 at 12:09 -0400, Tom Lane wrote: > > > "Florian G. Pflug" <[EMAIL PROTECTED]> writes: > > > > I've now thought about how to fix that without doing that

Re: [HACKERS] Forcing wal rotation

2006-07-16 Thread Hannu Krosing
Ühel kenal päeval, L, 2006-07-15 kell 22:24, kirjutas Tom Lane: > Hannu Krosing <[EMAIL PROTECTED]> writes: > > And by any chance, do you plan to backport the standby WAL playback mode > > patches to 8.0 and 8.1 series ? > > That's not happening ... we do not put new features in stable branches.

Re: [HACKERS] Forcing wal rotation

2006-07-15 Thread Tom Lane
Hannu Krosing <[EMAIL PROTECTED]> writes: > And by any chance, do you plan to backport the standby WAL playback mode > patches to 8.0 and 8.1 series ? That's not happening ... we do not put new features in stable branches. regards, tom lane ---(end

Re: [HACKERS] Forcing wal rotation

2006-07-15 Thread Hannu Krosing
Ühel kenal päeval, R, 2006-07-14 kell 17:39, kirjutas Simon Riggs: > On Fri, 2006-07-14 at 12:09 -0400, Tom Lane wrote: > > "Florian G. Pflug" <[EMAIL PROTECTED]> writes: > > > I've now thought about how to fix that without doing that rather crude > > > rsync-pg_xlog-hack. > > > I've read through

Re: [HACKERS] Forcing wal rotation

2006-07-14 Thread Florian G. Pflug
Simon Riggs wrote: On Fri, 2006-07-14 at 12:09 -0400, Tom Lane wrote: "Florian G. Pflug" <[EMAIL PROTECTED]> writes: I've now thought about how to fix that without doing that rather crude rsync-pg_xlog-hack. I've read through the code, and learned that wal-segments are expected to have a spec

Re: [HACKERS] Forcing wal rotation

2006-07-14 Thread Simon Riggs
On Fri, 2006-07-14 at 12:09 -0400, Tom Lane wrote: > "Florian G. Pflug" <[EMAIL PROTECTED]> writes: > > I've now thought about how to fix that without doing that rather crude > > rsync-pg_xlog-hack. > > I've read through the code, and learned that wal-segments are expected to > > have a specific

Re: [HACKERS] Forcing wal rotation

2006-07-14 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Florian G. Pflug > Sent: 14 July 2006 16:37 > To: Postgresql-General > Cc: A.M. > Subject: Re: [HACKERS] Forcing wal rotation > > > How about an SQL-level fu

Re: [HACKERS] Forcing wal rotation

2006-07-14 Thread Tom Lane
"Florian G. Pflug" <[EMAIL PROTECTED]> writes: > I've now thought about how to fix that without doing that rather crude > rsync-pg_xlog-hack. > I've read through the code, and learned that wal-segments are expected to > have a specific size - > thus rotating them "early" is not that easy. Simon

Re: [HACKERS] Forcing wal rotation

2006-07-14 Thread Florian G. Pflug
Martijn van Oosterhout wrote: On Fri, Jul 14, 2006 at 05:36:58PM +0200, Florian G. Pflug wrote: That was the idea - providing pg_rotate_wal(), which would guarantee that the wal is rotatted at least once if called. Thinking further about this, for a first prove of concept, I'd be enough to write

Re: [HACKERS] Forcing wal rotation

2006-07-14 Thread Martijn van Oosterhout
On Fri, Jul 14, 2006 at 05:36:58PM +0200, Florian G. Pflug wrote: > That was the idea - providing pg_rotate_wal(), which would guarantee that > the wal is rotatted at least once if called. Thinking further about this, > for a first prove of concept, I'd be enough to write a C function > pg_current_

Re: [HACKERS] Forcing wal rotation

2006-07-14 Thread Florian G. Pflug
A.M. wrote: On Fri, July 14, 2006 11:20 am, Florian G. Pflug wrote: Hi For my warm-standby-cluster I'm now saving the currently used wal using rsync, to avoid loosing data from a few hours (or days) ago, when there is little traffic, and thus the wal isn't rotated. For online backups, the prob