Dear Oliver,
Kindly do not remove any WAL file from pg_wal. You should consider checking
out following settings in the postgresql.conf file.
1) wal_keep_segments
- This setting enable retention of last this number of files. e.g. if this
parameter is set to 256, last 256 files will not be deleted.
At Thu, 2 Sep 2021 08:21:37 +0200, wrote in
> Hy Kyotaro,
>
> Thanks for this explanation. I joined the files to be complete.
Thanks, it is informative. It looks like this if sorted in the file-name order.
01/09/2021 12:1516 777 216 0001008E0061.deleted
01/09/2021 16:35
:41
À : o.lepre...@gmail.com
Cc : pgsql-gene...@postgresql.org
Objet : Re: oldest WAL files not removed
At Wed, 1 Sep 2021 12:48:51 +0200, wrote in
> Hi,
>
>
>
> Looking at WAL folder after a crash, I noticed that new files after
> restarting overwrite the more recent files before t
At Wed, 1 Sep 2021 12:48:51 +0200, wrote in
> Hi,
>
>
>
> Looking at WAL folder after a crash, I noticed that new files after
> restarting overwrite the more recent files before the crash and not the
> oldest, which was what I expected.
>
> Is that normal ? I got only one file marked .dele
Hi,
Looking at WAL folder after a crash, I noticed that new files after
restarting overwrite the more recent files before the crash and not the
oldest, which was what I expected.
Is that normal ? I got only one file marked .deleted. Does that happens
when a WAL file hase been completed updat
