@Sovereign @dcc @ins0mniak @nyanide @lain @lord_nougat @lain @verita84 Yeah, some of these little Pleroma administration tricks aren't documented well and most of the knowledge spreads through asking/observing others.
In this backup DB case, the official docs just say, run pg_dump -Fc ... and restore the schema and data at once.
Gleason made a GitLab snippet which avoids the annoying long index build problem, but at the same time, the commands he gives you actually don't work, because the disabled triggers at data import need database superuser (postgres) privileges and he runs the restore as the normal pleroma user.
And Pete wrote a blog post about the annoying index and how to actually work around it at the bottom of the article. And that should work with the custom format, but I've never tried it, so use at your own risk.