Re: postgres wal log configuration question

> On May 7, 2019, at 10:58 AM, Pavan Kumar <pavan(dot)dba27(at)gmail(dot)com> wrote:
>
>
>
> how do i understand the output ? Is this wal segment name ? If yes, when i look at wal log location i do see below output. how do i correlate query output with os command output ?
>
> postgres=# select pg_switch_wal();
> pg_switch_wal
> ---------------
> C/E000158
> (1 row)
>

Use pg_walfile_name(); i.e.

enso=# select pg_switch_wal();
pg_switch_wal
---------------
29CF/4D14B48
(1 row)

enso=# select pg_walfile_name('29CF/4D14B48');
pg_walfile_name
--------------------------
00000001000029CF00000000
(1 row)

enso=# select pg_walfile_name(pg_switch_wal());
pg_walfile_name
--------------------------
00000001000029CF00000001
(1 row)