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 ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| >>> 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 |