On Wed, February 24, 2010 20:40, Erik Rijkers wrote: > > > pg_last_xlog_receive_location | pg_xlogfile_name_offset > -------------------------------+----------------------------------- > E2/C012AD90 | (00000000000000E2000000C0,1224080) > (1 row) > > These zero-timeline filenames look suspicious, no?
Sorry, I've only now noticed that this issue is already on the v9.0 TODO for Streaming Replication: "pg_xlogfile_name(pg_last_xlog_receive/replay_location()) might report the wrong name. Because a backend cannot know the actual timeline which is related to the location. " http://archives.postgresql.org/message-id/3f0b79eb1001190135vd9f62f1sa7868abc1ea61...@mail.gmail.com so, nevermind.. Erik Rijkers -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers