On 1/15/15 8:41 PM, Fabio Ugo Venchiarutti wrote:
Does it mean that pg_last_xlog_receive_location() returns the last WAL record that has been successfully "staged for replay" by the stream replication whereas pg_last_xlog_replay_location() returns the last successful WAL replay regardless of it coming from streaming or archive shipping? As in 2 different stages the first of which is basically irrelevant to record visibility?
(At least in -HEAD) receive is what's been committed to disk; replay is what's actually been replayed and should be visible. -- Jim Nasby, Data Architect, Blue Treble Consulting Data in Trouble? Get it in Treble! http://BlueTreble.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general