staging postgres dr broken due to missing wal files
I changed archive_command to a script that archive to both wal-g and wal-e
#!/bin/bash /usr/bin/envdir /etc/wal-e.d/env /opt/wal-e/bin/wal-e wal-push $1 && \ /usr/bin/envdir /etc/wal-g.d/env /opt/wal-g/bin/wal-g wal-push $1 &>>/var/log/wal-g/wal-g.log
something happened between 1/11 04:15:00 UTC to 1/11 04:16:00 UTC, one wal file 000000370000350A00000062 didn’t get archived to wal-e, but is correctly archived to wal-g. not sure why would wal-e skip that wal file but wal-g still able to archive it?
This caused the dr broken, so I had to reset the replication