You are right, but it's still a manual step I have to remind myself how to perform every time I upgrade. Thankfully the OpenBSD docs remind me, otherwise I wouldn't remember:

https://www.openbsd.org/faq/upgrade77.html

https://github.com/openbsd/ports/blob/master/databases/postg...