basic_archive lost archive_directory

From: Олег Самойлов <splarv(at)ya(dot)ru>
To: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: basic_archive lost archive_directory
Date: 2026-01-29 08:41:42
Message-ID: 73271769675212@mail.yandex.ru
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

<div>Debian 13.3</div><div><div>Postgresql 17.7-3.pgdg13+1 from PGDG</div><div> </div><div>PostgreSQL was configured to wrote WAL archive into NFS server. After some time, suddenly, WAL writing stopped. In the log:<div><span style="font-family:'courier new' , monospace">2026-01-23 18:46:49.970 MSK,,,12085,,697397e9.2f35,1,,2026-01-23 18:46:49 MSK,,0,WARNING,22023,"invalid value for parameter ""basic_archive.archive_directory"": ""/mnt/ocean/postgres/stars/WAL""","Specified archive directory does not exist.",,,,,,,,"","archiver",,0</span></div><div><span style="font-family:'courier new' , monospace">2026-01-23 18:57:23.589 MSK,,,12085,,697397e9.2f35,2,,2026-01-23 18:46:49 MSK,,0,WARNING,01000,"""archive_mode"" enabled, yet archiving is not configured","basic_archive.archive_directory is not set.",,,,,,,,"","archiver",,0</span><br />And the last row repeated several days, pg_wal raised up to 4 TiB. I checked, the <span style="font-family:'courier new' , monospace">basic_archive.archive_directory </span><span style="font-family:'arial' , sans-serif">was configured:</span></div><div><div><span style="font-family:'courier new' , monospace">postgres=# show basic_archive.archive_directory;</span></div><div><span style="font-family:'courier new' , monospace">     basic_archive.archive_directory</span></div><div><span style="font-family:'courier new' , monospace">-----------------------------------------</span></div><div><span style="font-family:'courier new' , monospace"> /mnt/ocean/postgres/stars/WAL</span></div><div><span style="font-family:'courier new' , monospace">(1 row)</span></div><div>And directory existed and it has old WAL files (before error raised).</div><div>The basic_archive is unstable, but I don't know how to repeat this. Workaround: use the oldschool archive_command .</div></div></div></div>

Attachment Content-Type Size
unknown_filename text/html 1.8 KB

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2026-01-30 15:59:18 BUG #19391: pg_ctl: the PID file "/xxxx/postmaster.pid" is empty
Previous Message PG Bug reporting form 2026-01-28 09:54:19 BUG #19390: Defects in the test case partition_merge