Way to get timeline

From: Vladimir Borodin <root(at)simply(dot)name>
To: pgsql-general(at)postgresql(dot)org
Subject: Way to get timeline
Date: 2015-07-20 08:13:33
Message-ID: E47A0A7C-923B-40FE-8B02-A77F881BD101@simply.name
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all.

What is the best way to get current timeline of host? Right now I can imagine two variants:

1. Do checkpoint and read it from control file.
2. Do something like "SELECT substr(pg_xlogfile_name(pg_current_xlog_location()), 1, 8)".

Both variants seem to be a bit tricky. Is there a way better?

Thanks.

--
May the force be with you…
https://simply.name

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ramesh T 2015-07-20 10:00:51 Postgres Recovery
Previous Message Amitabh Kant 2015-07-20 03:59:22 Re: Upgrade postgres cluster on FreeBSD using pg_upgrade