News for hackers. Stuff that matters.

A comment on A faster way to copy SQLite databases between computers. Parent comment

Re:A faster way to copy SQLite databases between computers by aitchnyu on Friday May 02, 2025 @02:52AM (#43866911)
Whats the closest counterpart in Postgres ecosystem?
[ Parent | on HN ]
Re:A faster way to copy SQLite databases between computers by j16sdiz on Friday May 02, 2025 @06:43AM (#43868120)
log shipping[1] or logical replication[2]

[1] https://www.postgresql.org/docs/current/warm-standby.html [2] https://www.postgresql.org/docs/current/logical-replication....

[ Parent | on HN ]
Re:A faster way to copy SQLite databases between computers by rsync on Friday May 02, 2025 @03:06PM (#43873574)
This isn't what you mean but I can't resist:

  pg_dump -U postgres db | ssh [email protected] "dd of=db_dump"
[ Parent | on HN ]