Replace wal-g for postgresql wal archiving

[Firefishy]

Currently we use wal-g for OpenStreetMap.org database archiving.

We need to decide and switch to a supported replacement.

Likely options:

• pgbackreset
• pg barman

[pnorman]

Which version of wal-g do we have? The project is still active so I'm surprised it doesn't work with PG 17.

[pnorman]

Reading through various talk slides it looks like s3 support is DIY for barman but built in for pgbackrest. pgbackrest seems to have better parallelism on large databases.

barman seems to handle multiple clusters better.

On the postgresql IRC channel pgbackrest is recommended more often than barman (135 times vs 6 times this year)

Given our usecase involve a very large database and WAL on S3, it sounds like pgbackrest is the better option for us.

[Firefishy]

Which version of wal-g do we have? The project is still active so I'm surprised it doesn't work with PG 17.

There are no releases of wal-g that supports PG15+ wal-g/wal-g#1909 , the issue was first reported back in 2022.

[Firefishy]

I've created a S3 bucket and access key for dev to test alternatives: #1299