Postgres Pro
Downloads
Home   >   mailing lists

Re: WAL's listing in pg_xlog by some sql query - Mailing list pgsql-general

From Sameer Kumar
Subject Re: WAL's listing in pg_xlog by some sql query
Date
Msg-id CADp-Sm6GPTxWeOW66-m-rDy1gubtPuW36XbY_w1UganuOcHdrg@mail.gmail.com
Whole thread Raw
In response to WAL's listing in pg_xlog by some sql query  (Alex Ignatov <a.ignatov@postgrespro.ru>)
Responses Re: WAL's listing in pg_xlog by some sql query
List pgsql-general
Tree view


On Fri, 3 Jun 2016, 12:14 a.m. Alex Ignatov, <a.ignatov@postgrespro.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

pgsql-general by date:

Previous
From: Alex Ignatov
Date:
Subject: WAL's listing in pg_xlog by some sql query
Next
From: John R Pierce
Date:
Subject: Re: Replication