alt Hacker News- anyone knows what is the equivalent of litestream for postgres? - i want to be able to pg_dump and barman my database to s3 by streaming it. is that possible?
Replies
direwolf20 • yesterday at 10:00 PM
Did Postgres's WAL archiving feature not work for you?
Eikon • yesterday at 9:58 PM
You might be interested in ZeroFS [0], it works great with Postgres [1].
To achieve what you describe, you should be just able to setup a Postgres replica that’s setup on top of ZeroFS.
[0] https://github.com/Barre/ZeroFS
[1] https://github.com/Barre/ZeroFS?tab=readme-ov-file#postgresq...
There is wal-g that moves the wal files to s3 and you can spin up any number of instances off of that. Works great for catching up secondary servers