Postgres Pro
Downloads
Home   >   mailing lists

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

From Pavan Kumar
Subject Re: postgres wal log configuration question
Date
Msg-id CA+M0sHGsvHdP-c6ZZeeefy79fobFg5TaUBwZ9BqBCB=1rCfGwQ@mail.gmail.com
Whole thread Raw
In response to Re: postgres wal log configuration question  (Rui DeSousa <rui@crazybean.net>)
Responses Re: postgres wal log configuration question  (Rui DeSousa <rui@crazybean.net>)
List pgsql-admin
Tree view
Hello Rui,

My apologies for delayed response. 

Thank you so much for the information, it was helpful. another question I Have is , is there anyway to control wal segment naming format.  wal segment file is not generating in sequential format.



On Tue, May 7, 2019 at 10:36 AM Rui DeSousa <rui@crazybean.net> wrote:


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)






--
Regards,

#!  Pavan Kumar
-----------------------------------------------
Sr. Database Administrator..!
NEXT GENERATION PROFESSIONALS, LLC
Cell    #  267-799-3182 #  pavan.dba27 (Gtalk)  
India   # 9000459083

Take Risks; if you win, you will be very happy. If you lose you will be Wise  

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: LDAP authentication failed
Next
From: Pavan Kumar
Date:
Subject: Re: pg_receivewal configuration issues