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

2016-06-08 Thread Stephen Frost
* Michael Paquier (michael.paqu...@gmail.com) wrote: > On Mon, Jun 6, 2016 at 9:51 PM, Stephen Frost wrote: > > * Vik Fearing (v...@2ndquadrant.fr) wrote: > >> On 03/06/16 04:32, Michael Paquier wrote: > >> > On Fri, Jun 3, 2016 at 11:23 AM, Sameer Kumar > >> > wrote: > >> >> On Fri, Jun 3, 2016

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

2016-06-07 Thread Michael Paquier
On Mon, Jun 6, 2016 at 9:51 PM, Stephen Frost wrote: > * Vik Fearing (v...@2ndquadrant.fr) wrote: >> On 03/06/16 04:32, Michael Paquier wrote: >> > On Fri, Jun 3, 2016 at 11:23 AM, Sameer Kumar >> > wrote: >> >> On Fri, Jun 3, 2016 at 4:30 AM Stephen Frost wrote: >> >>> Given the usefulness of

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

2016-06-06 Thread Stephen Frost
* Vik Fearing (v...@2ndquadrant.fr) wrote: > On 03/06/16 04:32, Michael Paquier wrote: > > On Fri, Jun 3, 2016 at 11:23 AM, Sameer Kumar > > wrote: > >> On Fri, Jun 3, 2016 at 4:30 AM Stephen Frost wrote: > >>> Given the usefulness of this specific query and that it could be used > >>> without r

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

2016-06-05 Thread Michael Paquier
On Sat, Jun 4, 2016 at 11:34 PM, Vik Fearing wrote: > On 03/06/16 04:32, Michael Paquier wrote: >> pg_ls_dir() has a check on superuser() embedded in its code. > > So what? That's what SECURITY DEFINER is all about. Yes you are right. I missed completely the point :) Thanks for the reminder and

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

2016-06-04 Thread Vik Fearing
On 03/06/16 04:32, Michael Paquier wrote: > On Fri, Jun 3, 2016 at 11:23 AM, Sameer Kumar wrote: >> >> >> On Fri, Jun 3, 2016 at 4:30 AM Stephen Frost wrote: >>> >>> * Sameer Kumar (sameer.ku...@ashnik.com) wrote: On Fri, 3 Jun 2016, 12:14 a.m. Alex Ignatov, wrote: > Can I list all

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

2016-06-02 Thread Michael Paquier
On Fri, Jun 3, 2016 at 11:23 AM, Sameer Kumar wrote: > > > On Fri, Jun 3, 2016 at 4:30 AM Stephen Frost wrote: >> >> * Sameer Kumar (sameer.ku...@ashnik.com) wrote: >> > On Fri, 3 Jun 2016, 12:14 a.m. Alex Ignatov, >> > wrote: >> > > Can I list all WAL files in pg_xlog by using some sql query i

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

2016-06-02 Thread Sameer Kumar
On Fri, Jun 3, 2016 at 4:30 AM Stephen Frost wrote: > * Sameer Kumar (sameer.ku...@ashnik.com) wrote: > > On Fri, 3 Jun 2016, 12:14 a.m. Alex Ignatov, > > wrote: > > > Can I list all WAL files in pg_xlog by using some sql query in > Postgres? > > > > Try > > > > Select pg_ls_dir('pg_xlog'); > >

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

2016-06-02 Thread Stephen Frost
David, * David G. Johnston (david.g.johns...@gmail.com) wrote: > On Thu, Jun 2, 2016 at 4:29 PM, Stephen Frost wrote: > > > * Sameer Kumar (sameer.ku...@ashnik.com) wrote: > > > On Fri, 3 Jun 2016, 12:14 a.m. Alex Ignatov, > > > wrote: > > > > Can I list all WAL files in pg_xlog by using some

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

2016-06-02 Thread David G. Johnston
On Thu, Jun 2, 2016 at 4:29 PM, Stephen Frost wrote: > * Sameer Kumar (sameer.ku...@ashnik.com) wrote: > > On Fri, 3 Jun 2016, 12:14 a.m. Alex Ignatov, > > wrote: > > > Can I list all WAL files in pg_xlog by using some sql query in > Postgres? > > > > Try > > > > Select pg_ls_dir('pg_xlog'); >

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

2016-06-02 Thread Stephen Frost
* Sameer Kumar (sameer.ku...@ashnik.com) wrote: > On Fri, 3 Jun 2016, 12:14 a.m. Alex Ignatov, > wrote: > > Can I list all WAL files in pg_xlog by using some sql query in Postgres? > > Try > > Select pg_ls_dir('pg_xlog'); Note that this currently requires superuser privileges. Given the usefu

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

2016-06-02 Thread Sameer Kumar
On Fri, 3 Jun 2016, 12:14 a.m. Alex Ignatov, 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 > > > -- -- Be