Search Postgresql Archives
Old .deleted file in pg_wal
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- Subject: Old .deleted file in pg_wal
- From: Guy Burgess <guy@xxxxxxxxxxxxx>
- Date: Sat, 27 Feb 2021 09:48:47 +1300
- User-agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Thunderbird/78.7.1
Hello,
There is a file in my pg_wal directory called
"000000010000003B000000D0.deleted", last modified in December 2020, and
has survived PG & server restarts. I've been having some errors with
WAL files
(https://www.postgresql.org/message-id/flat/095ccf8d-7f58-d928-427c-b17ace23cae6%40burgess.co.nz)
and would like to tidy this file if safe to do so.
I think this is where the file gets created:
https://github.com/postgres/postgres/blob/ca3b37487be333a1d241dab1bbdd17a211a88f43/src/backend/access/transam/xlogarchive.c#L406
Based on that I'm pretty sure it is OK to delete a ".deleted" WAL file,
but thought I would check in case anyone suggests otherwise.
Thanks
Guy
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]