I got one main server and other two servers are replicating from the main.
I got full disk space on the main server (I have an
archive_command that put wal archives into the
It got full, and the PostgreSQL log shows the error:
archive command failed: 2019-06-04 09:52:49.079 EEST  LOG: archive command failed with exit code 1 2019-06-04 09:52:49.079 EEST  DETAIL: The failed archive command was: test ! -f /wal_archive/000000010000028C0000003B && cp pg_xlog/000000010000028C0000003B /wal_archive/000000010000028C0000003B
I cleaned up the
/wal_archive/ directory with
pg_archivecleanup, but PostgreSQL still throws the same error.
I have tried to reload PostgreSQL config without making changes to the config itself and without restart using:
but still the same, in log, PostgreSQL throws an error. How should I resume wal_archive copying to the wal_archive directory?
Should I change
true, reload, and change archive back to original again?
I'm trying to avoid restarting the server itself.