Skip site navigation (1) Skip section navigation (2)

Re: xlog filename formatting functions in recovery

From: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
To: Daniel Farina <daniel(at)heroku(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: xlog filename formatting functions in recovery
Date: 2012-07-03 08:34:09
Message-ID: 4FF2AE81.9030001@catalyst.net.nz (view raw or flat)
Thread:
Lists: pgsql-hackers
On 03/07/12 20:24, Daniel Farina wrote:
> Hello,
>
> I've noticed recently that I can't seem to use the convenient xlog
> filename formatting functions while I'm in a standby.  I don't see an
> incredibly obvious reason why that is the case, so here's a patch that
> simply removes the ban on being able to call these formatting
> functions.
>
> Perhaps I'm missing something, but it feels like this is an oversight
> from the days when there was no useful function to call that formatted
> a X/X-type record on a standby.
>
>
>

I must add a +1 to that, gotta be my pet peeve with this otherwise fine 
functionality. Also it would be really nice to have a single function 
that gave the current receive or active wal offset so things like Nagios 
didn't have to know the if db is a standby or not to work out said offset...

Regards

Mark

In response to

pgsql-hackers by date

Next:From: Kyotaro HORIGUCHIDate: 2012-07-03 08:59:38
Subject: Re: pl/perl and utf-8 in sql_ascii databases
Previous:From: Daniel FarinaDate: 2012-07-03 08:31:44
Subject: Re: xlog filename formatting functions in recovery

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group