Shameless plug: https://github.com/mkleczek/pgwrh automates it quite a bit.