Re: Forcing current WAL file to be archived

Hannu Krosing wrote:
> ?hel kenal p?eval, T, 2006-07-25 kell 11:27, kirjutas Bruce Momjian:
> > Hannu Krosing wrote:
> > > ?hel kenal p?eval, T, 2006-07-25 kell 10:51, kirjutas Bruce Momjian:
> > > > Where are we on these TODO items:
> > > >
> > >
> > > > o Add reporting of the current WAL file, perhaps as part of
> > > > partial log file archiving
> > >
> > > It would be nice to have a function that tells both filename and offset
> > > of current WAL file, so it would be possible to do live async streaming
> > > of up-to-subsecond changes without too much overhead.
> >
> > OK, "offset" added to TODO item. What would the offset give us?
>
> the offset returned by lseek() on the WAL file, that is the end of the
> part of the WAL file which has actually been written to.

Sorry, I was actually asking what use the offset would be to a user.

--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +