Re: Archive# views

Поиск
Список
Период
Сортировка
От Kapil Agarwal
Тема Re: Archive# views
Дата
Msg-id CAORFk+PBansAov=pzua-RqKbMGb34_9Bz+giKpjmLukAJ5VJ5w@mail.gmail.com
обсуждение исходный текст
Ответ на Archive# views  (Satish K Biradar <satishbiradar1984@gmail.com>)
Ответы Re: Archive# views
Re: Archive# views
Список pgsql-general
Дерево обсуждения
Hi Satish,

You can calculate the replication lag by comparing the current WAL write location on the primary with the last WAL location received/replayed by the standby. They can be retrieved using pg_current_xlog_location on the primary and the pg_last_xlog_receive_location/pg_last_xlog_replay_location on the standby, respectively.  


Master Server:

SELECT pg_current_xlog_location(); 


Slave server:

select pg_last_xlog_receive_location();

select now() - pg_last_xact_replay_timestamp();

Hope this help.



On Fri, May 30, 2014 at 11:57 AM, Satish K Biradar <satishbiradar1984@gmail.com> wrote:
Hello,

I am a newbee to Postgresql and I want to build replication between master
and slave servers(8.4). I was able to set it up but I cannot check archive#
at master and slave servers as what was the last archive# generated at
master and what is current archive# at Slave server that is being replayed.

Is there any view in PostgreSQL with which I can find the details of
Archive# generation at Master and archive# that is replaying currently or
last/recent archive# that has replayed at slave server.

So can you please provide me the commands as how to check the last archive#
is generated at master and slave(being replayed), lag between master and
slave servers.


Thanks & regards,
Satish K.



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Archive-views-tp5805521.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--
 

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

Предыдущее
От: snowsnake
Дата:
Сообщение: database system was interrupted sometimes untill we restart it can be used
Следующее
От: John R Pierce
Дата:
Сообщение: Re: database system was interrupted sometimes untill we restart it can be used