Postgres Pro
Downloads
Home   >   mailing lists

Re: How to get current timeline of host in postgres 10.4? - Mailing list pgsql-admin

From Pavan Teja
Subject Re: How to get current timeline of host in postgres 10.4?
Date
Msg-id CACh9nsbxQt-8qqw-sfUH1cpKnUViRdYrqWnmf5pagLo+Ch17oQ@mail.gmail.com
Whole thread Raw
In response to How to get current timeline of host in postgres 10.4?  (Debraj Manna <subharaj.manna@gmail.com>)
List pgsql-admin
Tree view

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.manna@gmail.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,

pgsql-admin by date:

Previous
From: Debraj Manna
Date:
Subject: How to get current timeline of host in postgres 10.4?
Next
From: Shreeyansh Dba
Date:
Subject: Re: How to get current timeline of host in postgres 10.4?