Unix Technical Forum

how is pitr replay interruption time determined?

This is a discussion on how is pitr replay interruption time determined? within the pgsql Admins forums, part of the PostgreSQL category; --> >>> On Wed, Aug 29, 2007 at 9:48 AM, in message <200708291048.54662.xzilla@users.sourceforge.net >, Robert Treat <xzilla@users.sourceforge.net> wrote: > Looking ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Admins

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #11 (permalink)  
Old 04-10-2008, 08:12 AM
Kevin Grittner
 
Posts: n/a
Default Re: how is pitr replay interruption time determined?

>>> On Wed, Aug 29, 2007 at 9:48 AM, in message
<200708291048.54662.xzilla@users.sourceforge.net >, Robert Treat
<xzilla@users.sourceforge.net> wrote:
> Looking at last checkpoint location in pg_control, I see:
> Latest checkpoint location: 1C/8001E848
>
> How does one translate that into an xlog file name?


Unless you've gotten fancy in a PITR recovery, it should be:

000000010000001C00000080

01E848 is the offset into the file.

-Kevin




---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:19 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com