Email or username:

Password:

Forgot your password?
Johannes's posts Post Back to profile
Johannes Ernst
4 comments
Christian Pietsch 🍑

@J12t I guess this is mandatory reading for all #mastoadmin people that run PostgreSQL in a replication setup with read access to the standby server.

29 Jul 2023 at 9:13 | Open on digitalcourage.social
Ross of Ottawa

@J12t reads like a who-dunnit novel. Good summary.

29 Jul 2023 at 12:50 | Open on mastodon.social
Hazelnoot

@J12t this is excellent, one of the best writeups I've ever read for an issue of this scale and complexity!

29 Jul 2023 at 13:19 | Open on mastodon.koehlercode.dev
Thomas Guyot-Sionnest

@J12t quite interesting read indeed... I would've probably tried sed first for the 54GB edits, or used head/tail in line mode... Assuming file is proper text with newlines of course (IIRC how MySQL dumps are, I don't know about PostgreSQL). In any case with vim use binary+noeol for edits of huge and/or binary files. 🙂

30 Jul 2023 at 12:38 | Open on noc.social
Go Up