On Thu, Feb 25, 2010 at 7:48 PM, Fujii Masao wrote:
> On Thu, Feb 25, 2010 at 7:22 PM, Heikki Linnakangas
> wrote:
>> Yeah. The current pg_*_last_location() functions don't cut it though,
>> you need to retain logs back to the redo location of the last
>> restartpoint. That's what %r returns. May
On Thu, Feb 25, 2010 at 7:22 PM, Heikki Linnakangas
wrote:
> Yeah. The current pg_*_last_location() functions don't cut it though,
> you need to retain logs back to the redo location of the last
> restartpoint. That's what %r returns. Maybe we should add another function?
+1
It would be useful i
Fujii Masao wrote:
> On Thu, Feb 25, 2010 at 5:10 PM, Heikki Linnakangas
> wrote:
>> A quick fix would be to just throw an error if you try to use
>> pg_xlog_filename() during hot standby. But there seems to be good
>> reasons to call pg_xlog_filename() during hot standby, given that both
>> of yo
On Thu, Feb 25, 2010 at 5:10 PM, Heikki Linnakangas
wrote:
> A quick fix would be to just throw an error if you try to use
> pg_xlog_filename() during hot standby. But there seems to be good
> reasons to call pg_xlog_filename() during hot standby, given that both
> of you ran into the same issue.
Fujii Masao wrote:
> On Thu, Feb 25, 2010 at 9:31 AM, Erik Rijkers wrote:
>> On Wed, February 24, 2010 20:40, Erik Rijkers wrote:
>>>
>>> pg_last_xlog_receive_location | pg_xlogfile_name_offset
>>> ---+---
>>> E2/C012AD90
On Thu, Feb 25, 2010 at 9:31 AM, Erik Rijkers wrote:
> On Wed, February 24, 2010 20:40, Erik Rijkers wrote:
>>
>>
>> pg_last_xlog_receive_location | pg_xlogfile_name_offset
>> ---+---
>> E2/C012AD90 | (000
On Wed, February 24, 2010 20:40, Erik Rijkers wrote:
>
>
> pg_last_xlog_receive_location | pg_xlogfile_name_offset
> ---+---
> E2/C012AD90 | (00E200C0,1224080)
> (1 row)
>
> These zero-timeline fil
I should have added that (on the slave) all pg_xlog/ files have timeline 1
like: 000100E200C0
On Wed, February 24, 2010 20:40, Erikruary 24, 2010 20:40, Er Rijkers wrote:
> I have two 9.0devel machines (*not* alpha but cvs as of 2010.02.19 22.48).
>
> One primary, one slave.
>
> In a
I have two 9.0devel machines (*not* alpha but cvs as of 2010.02.19 22.48).
One primary, one slave.
In an attempt to keep track of standby progression (versus primary), I ran
slave-side:
replicas=# select
pg_last_xlog_replay_location()
pg_xlogfile_name_offset(pg_l
