>>> On Wed, Aug 29, 2007 at 9:48 AM, in message <200708291048.54662.xzilla@xxxxxxxxxxxxxxxxxxxxx>, Robert Treat <xzilla@xxxxxxxxxxxxxxxxxxxxx> 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
