Way to get timeline

[Vladimir Borodin <root@xxxxxxxxxxx>]

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