Re: Streaming replication and pg_xlogfile_name()
Erik Rijkers <er@xs4all.nl>
From: "Erik Rijkers" <er@xs4all.nl>
To: "Fujii Masao" <masao.fujii@gmail.com>
Cc: "Heikki Linnakangas" <heikki.linnakangas@enterprisedb.com>, "PostgreSQL-development" <pgsql-hackers@postgresql.org>
Date: 2010-03-05T00:20:11Z
Lists: pgsql-hackers
On Wed, March 3, 2010 15:03, Fujii Masao wrote: > On Tue, Mar 2, 2010 at 10:52 PM, Fujii Masao <masao.fujii@gmail.com> wrote: > > Here is the revised patch. I used new local variable instead of lastPageTLI > to track the tli of last applied record. It is updated with the tli of the > log page header when reading the page, and with the tli of the checkpoint > record when replaying the checkpoint shutdown record that changes the tli. > So pg_last_xlog_replay_location() can return the accurate tli of the last > applied record. > > extend_format_of_recovery_info_funcs_v4.patch looks good: on the standby, the initial xlog file_name immediately after startup is now 000000010000000000000001, as expected. I'll do my further testing of HS/SR with this patch included. thanks, Erik Rijekrs