Re: postgres wal log configuration question

On May 7, 2019, at 10:58 AM, Pavan Kumar <pavan.dba27@gmail.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)