Remix.run Logo
vivzkestrel 5 days ago

- 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?

pbrumm 4 days ago | parent | next [-]

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

vivzkestrel 4 days ago | parent [-]

just a quick look on it, is that more like pg_dump or barman?

direwolf20 5 hours ago | parent | prev | next [-]

Did Postgres's WAL archiving feature not work for you?

Eikon 5 hours ago | parent | prev [-]

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...