Re: strange behavior of WAL files

this is a very interesting case.  Atul keep us posted.

Re: strange behavior of WAL files

Atul Kumar writes: > Please check my findings below > older > -rw--- 1 enterprisedb enterprisedb 16777216 Jun 2 02:47 > 000136CF00A4 > -rw--- 1 enterprisedb enterprisedb 16777216 Jun 2 02:45 > 000136CF00A3 > -rw--- 1 enterprisedb enterprisedb 16777216 Jun 2

Re: strange behavior of WAL files

it gets cleaned up for me. turn archiving on, simulate success using /bin/true turn archiving off, simulate success using /bin/false generate wals by some DMLS. postgres@go:~/pgsql/data/pg_wal$ grep wal_size ../postgresql.conf max_wal_size = 100MB min_wal_size = 80MB postgres@go:~/pgsql/data/pg_

Re: strange behavior of WAL files

hi Tom, Please check my findings below older -rw--- 1 enterprisedb enterprisedb 16777216 Jun 2 02:47 000136CF00A4 -rw--- 1 enterprisedb enterprisedb 16777216 Jun 2 02:45 000136CF00A3 -rw--- 1 enterprisedb enterprisedb 16777216 Jun 2 02:44 000136CF000

Re: strange behavior of WAL files

Hi Jehan, Just to add little more info about this issue is : We have set value 4000 for parameter wal_keep_segments. So is there any chance that after a certain number of WAL files, postgres will start recycling the WAL with same name ? Please share your valuable suggestion. Regards. Atul

Re: strange behavior of WAL files

Atul Kumar writes: > once old WAL files of pg_xlog directory are archived in > '/nfslogs/wal/' directory then these WAL files are getting generated > with the same name in pg_xlog directory. Are you sure you are describing the behavior accurately? What I would expect to happen, once an old WAL f

Re: strange behavior of WAL files

y is this happening ? >> >> >> >> please help me with your suggestions. >> >> >> Regards. >> >> >> >> >> On 6/4/21, Jehan-Guillaume de Rorthais wrote: >> > On Fri, 4 Jun 2021 15:39:30 +0530 >> > Atul Kumar wrote:

Re: strange behavior of WAL files

> my query is Why is this happening ? > > > > please help me with your suggestions. > > > Regards. > > > > > On 6/4/21, Jehan-Guillaume de Rorthais wrote: > > On Fri, 4 Jun 2021 15:39:30 +0530 > > Atul Kumar wrote: > > > >> HI, > &

Re: strange behavior of WAL files

my query is Why is this happening ? please help me with your suggestions. Regards. On 6/4/21, Jehan-Guillaume de Rorthais wrote: > On Fri, 4 Jun 2021 15:39:30 +0530 > Atul Kumar wrote: > >> HI, >> >> We have a centos 6 enviornment where postgres 9.6 is runni

Re: strange behavior of WAL files

On Fri, 4 Jun 2021 15:39:30 +0530 Atul Kumar wrote: > HI, > > We have a centos 6 enviornment where postgres 9.6 is running on it. > > We have strange behavior of WAL files of pg_xlog directory > > As we have set archive_command to archive WAL files at differe

strange behavior of WAL files

HI, We have a centos 6 enviornment where postgres 9.6 is running on it. We have strange behavior of WAL files of pg_xlog directory As we have set archive_command to archive WAL files at different location and the archive_command is working fine. So strange behavior is : We have a WAL file say