Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_resetxlog output clarification

pg_resetxlog output clarification

From
Peter Eisentraut
Date:
What do these output lines in pg_resetxlog of 8.3 mean?
   First log file ID for new XLOG:   First log file segment for new XLOG:

What does it mean to have a "new XLOG"?

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

Re: pg_resetxlog output clarification

From
Tom Lane
Date:
Peter Eisentraut <peter_e@gmx.net> writes:
> What do these output lines in pg_resetxlog of 8.3 mean?
>     First log file ID for new XLOG:
>     First log file segment for new XLOG:
> What does it mean to have a "new XLOG"?

Why does that wording surprise you?  pg_resetxlog is for wiping out
your xlog and starting fresh, no?
        regards, tom lane

Re: pg_resetxlog output clarification

From
Simon Riggs
Date:
On Tue, 2007-09-25 at 12:33 -0400, Tom Lane wrote:
> Peter Eisentraut <peter_e@gmx.net> writes:
> > What do these output lines in pg_resetxlog of 8.3 mean?
> >     First log file ID for new XLOG:
> >     First log file segment for new XLOG:
> > What does it mean to have a "new XLOG"?
> 
> Why does that wording surprise you?  pg_resetxlog is for wiping out
> your xlog and starting fresh, no?

Perhaps "after reset" would be better than "for new XLOG".

--  Simon Riggs 2ndQuadrant  http://www.2ndQuadrant.com

Re: pg_resetxlog output clarification

From
Peter Eisentraut
Date:
Am Dienstag, 25. September 2007 schrieb Simon Riggs:
> > Peter Eisentraut <peter_e@gmx.net> writes:
> > >     First log file ID for new XLOG:
> > >     First log file segment for new XLOG:

> Perhaps "after reset" would be better than "for new XLOG".

I like this better.  I have made the change.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/