Re: [GENERAL] Proper use of pg_xlog_location_diff()

2015-01-15 Thread Jim Nasby
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

Re: [GENERAL] Proper use of pg_xlog_location_diff()

2015-01-15 Thread Fabio Ugo Venchiarutti
On 16/01/15 14:37, Jim Nasby wrote: On 1/15/15 7:12 PM, Fabio Ugo Venchiarutti wrote: Greetings Our company is writing a small ad-hoc implementation of a load balancer for Postgres (`version()` = PostgreSQL 9.2.9 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.

Re: [GENERAL] Proper use of pg_xlog_location_diff()

2015-01-15 Thread Jim Nasby
On 1/15/15 7:12 PM, Fabio Ugo Venchiarutti wrote: Greetings Our company is writing a small ad-hoc implementation of a load balancer for Postgres (`version()` = PostgreSQL 9.2.9 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4), 64-bit). We're using both stre