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

From: Pavan Teja <pavan(dot)postgresdba(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:15:56
Message-ID: CACh9nsbxQt-8qqw-sfUH1cpKnUViRdYrqWnmf5pagLo+Ch17oQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Debraj,

From master:
pg_xlogfile_name -- right!
From standby:
using replication prtotocol (example from version 92)
psql -h "$host" -F' ' -c 'IDENTIFY_SYSTEM' 'dbname=replication
replication=true'
Hope it helps.

Regards,
Pavan
On Fri, Jun 15, 2018, 9:36 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

Browse pgsql-admin by date

  From Date Subject
Next Message Shreeyansh Dba 2018-06-15 16:27:07 Re: How to get current timeline of host in postgres 10.4?
Previous Message Debraj Manna 2018-06-15 16:05:18 How to get current timeline of host in postgres 10.4?