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)