Re: postgres wal log configuration question - Mailing list pgsql-admin

From Rui DeSousa
Subject Re: postgres wal log configuration question
Date
Msg-id 56496583-595D-4267-A5F3-7C1AA877345A@crazybean.net
Whole thread Raw
In response to Re: postgres wal log configuration question  (Pavan Kumar <pavan.dba27@gmail.com>)
Responses Re: postgres wal log configuration question
List pgsql-admin


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)




pgsql-admin by date:

Previous
From: SAMMY CRISWELL
Date:
Subject: Upgrade from psql version 9.3 to 9.6.
Next
From: Andres Freund
Date:
Subject: Re: Restoring from PostgreSQL 9.5 dump to 10 is super slow