3 ms·
"For replicating sqlite databases safely there is (litestream) ..." A reminder that litestream can run over plain old SFTP[1] which means you can stream databa
by rsync 1y ago
"For replicating sqlite databases safely there is (litestream) ..."
A reminder that litestream can run over plain old SFTP[1] which means you can stream database replication to just about any UNIX endpoint over SSH.
I have a favorite[2] but any SFTP server will do ...
[1] https://github.com/benbjohnson/litestream/issues/140 https://github.com/benbjohnson/litestream/issues/140
[2] https://www.rsync.net/resources/notes/2021-q3-rsync.net_technotes.html https://www.rsync.net/resources/notes/2021-q3-rsync.net_tech...
- aitchnyu 1y agoWhats the closest counterpart in Postgres ecosystem?
- j16sdiz 1y agolog shipping[1] or logical replication[2] [1] https://www.postgresql.org/docs/current/warm-standby.html https://www.postgresql.org/docs/current/warm-standby.html [2] https://www.postgresql.org/docs/current/logical-replication.html https://www.postgresql.org/docs/current/logical-replication....
- rsync 1y agoThis isn't what you mean but I can't resist: pg_dump -U postgres db | ssh user@rsync.net "dd of=db_dump"