pg_stat_replication in 9.3

Поиск
Список
Период
Сортировка
Искать
От
Torsten Förtsch
Тема
pg_stat_replication in 9.3
Дата
Msg-id
541583FC.8090909@gmx.net
Список
Дерево обсуждения
pg_stat_replication in 9.3 Torsten Förtsch <torsten.foertsch@gmx.net>
Re: pg_stat_replication in 9.3 Andy Colson <andy@squeakycode.net>
Re: pg_stat_replication in 9.3 Torsten Förtsch <torsten.foertsch@gmx.net>
Re: pg_stat_replication in 9.3 Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_stat_replication in 9.3 Torsten Förtsch <torsten.foertsch@gmx.net>
Hi,

I noticed a strange behaviour regarding pg_stat_replication in 9.3. If
called from psql using the \watch command, I see all my replicas. From
time to time one of them drops out and reconnects in a short period of
time, typically ~30 sec.

If I use the same select in plpgsql like:

  FOR r in SELECT application_name,
                  client_addr,
                  flush_location, clock_timestamp() AS lmd
             FROM pg_stat_replication
            ORDER BY application_name, client_addr
  LOOP
    RAISE NOTICE 'aname=%, ca=%, lmd=%, loc=%, cur=%, lag=%',
                 r.application_name, r.client_addr, r.lmd,
                 r.flush_location,
                 pg_current_xlog_location(),
                 pg_size_pretty(
                   pg_xlog_location_diff(
                     pg_current_xlog_location(),
                     r.flush_location
                   )
                 );
  END LOOP;

I see one of the replicas dropping out but never coming back again while
in a parallel session using psql and \watch it indeed does come back.

Is that intended?

Torsten

В списке pgsql-general по дате отправления
От: Bruce Momjian
Дата:
От: Kevin Grittner
Дата:
FAQ