Re: how to know current xlog location on standby after primary isdown

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: how to know current xlog location on standby after primary isdown
Дата
Msg-id 20180910065054.GH19122@paquier.xyz
обсуждение исходный текст
Ответ на how to know current xlog location on standby after primary is down  (magodo <wztdyl@sina.com>)
Список pgsql-general
Дерево обсуждения 
On Sun, Sep 09, 2018 at 10:29:08PM +0800, magodo wrote:
> So I want to know what is the correct way to do it. Thank you in
> advance!

There are pg_last_wal_receive_lsn() and pg_last_wal_replay_lsn() which
allow you to know what is the last LSN received and replayed on a
standby.  Those can be used when an instance is in recovery.
--
Michael
Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: "Ahmed, Nawaz"
Дата:
Сообщение: RE: connection error
Следующее
От: Csaba Ragasits
Дата:
Сообщение: PG8.3->10 migration data differences