Re: Couple of issues with pg_xlogdump - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Couple of issues with pg_xlogdump
Date
Msg-id 20130423115414.GB21867@awork2.anarazel.de
Whole thread Raw
In response to Re: Couple of issues with pg_xlogdump  (Pavan Deolasee <pavan.deolasee@gmail.com>)
Responses Re: Couple of issues with pg_xlogdump
List pgsql-hackers
On 2013-04-23 15:16:05 +0530, Pavan Deolasee wrote:
> > Which this confirms. This is likely the current end of wal. If you look
> > at pg_current_xlog_location() after starting the server again, it should
> > show an address nearby?
> >
> >
> Oh yes, you are right. Again, could there be a better way to report empty
> WAL files ? A general tendency would be to look at the last few WAL files
> in case failures or crashes and they are likely to be empty.

Hm. I don't really see what we could sensibly and easily do, but perhaps
I just lived with it for too long ;)

> > It works without either if you use explicit options like -s STARTADDR
> > and -p PATH which is frequently useful to just print a few records at
> > the correct point. I am not sure how could put that in there without
> > making it too complicated. Any suggestions?
> >
> >
> Ah ok. Can we mention these details at in the documentation ?
> http://www.postgresql.org/docs/devel/static/pgxlogdump.html

So something like:
At least one of STARTSEG, --start and --path or --rmgr=list has to be
specified.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: 9.3 Beta1 status report
Next
From: Jeevan Chalke
Date:
Subject: Re: REFRESH MATERIALIZED VIEW command in PL block hitting Assert