Re: How to get current timeline of host in postgres 10.4?

From: Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>
To: Debraj Manna <subharaj(dot)manna(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: How to get current timeline of host in postgres 10.4?
Date: 2018-06-15 16:27:07
Message-ID: CAGDYbUOxxFOVfrfx8EjcAB8FEyeUg7SDNR18U5793qqG0rs63A@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Debraj,

*Execute below query on Master Side : *
select pg_current_wal_lsn();
*Execute below query on Slave Side: *
using replication protocol (example from version 10.4)
psql -h "$host" -F' ' -c 'IDENTIFY_SYSTEM' 'dbname=replication
replication=true'
Hope it helps.

<http://www.shreeyansh.com>

On Fri, Jun 15, 2018 at 9:35 PM, Debraj Manna <subharaj(dot)manna(at)gmail(dot)com>
wrote:

> HI
>
> Can someone let me know what is the best way to get current timeline of
> host (in both master and the slaves) in postgres 10.4?
>
> Thanks,
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Debraj Manna 2018-06-15 16:41:48 Re: How to get current timeline of host in postgres 10.4?
Previous Message Pavan Teja 2018-06-15 16:15:56 Re: How to get current timeline of host in postgres 10.4?