Whats the closest counterpart in Postgres ecosystem? | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		aitchnyu 10 months ago \| parent \| context \| favorite \| on: A faster way to copy SQLite databases between comp... Whats the closest counterpart in Postgres ecosystem?

j16sdiz 10 months ago | [–]

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

rsync 10 months ago | [–]

This isn't what you mean but I can't resist:

  pg_dump -U postgres db | ssh user@rsync.net "dd of=db_dump"

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact