Re: WAL's listing in pg_xlog by some sql query

From: Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com>
To: Alex Ignatov <a(dot)ignatov(at)postgrespro(dot)ru>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: WAL's listing in pg_xlog by some sql query
Date: 2016-06-02 16:15:19
Message-ID: CADp-Sm6GPTxWeOW66-m-rDy1gubtPuW36XbY_w1UganuOcHdrg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 3 Jun 2016, 12:14 a.m. Alex Ignatov, <a(dot)ignatov(at)postgrespro(dot)ru>
wrote:

> Hello!
>
> Can I list all WAL files in pg_xlog by using some sql query in Postgres?
>

Try

Select pg_ls_dir('pg_xlog');

> --
> Alex Ignatov
> Postgres Professional: http://www.postgrespro.com
> The Russian Postgres Company
>
>
> --
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*

101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533

T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2016-06-02 16:39:07 Re: Replication
Previous Message Alex Ignatov 2016-06-02 16:13:34 WAL's listing in pg_xlog by some sql query