how to manage automatic updates

I'm giving some thought to scheduling automated updates of our PostgreSQL servers including the OS and application.

Updating the PostgreSQL executable is easy with the RPM repository that the PorstgreSQL community provides, but some of
the updates require changes to the system tables, stored procedures or other elements that reside in the database data. These
updates are not included in the RPM updates (for good reason) so they are missed if only RPM updates are performed.

Is there a best practice for applying database updates in an automated fashion?

Does anyone want to share what they are doing regarding automated database updates with regards to updating data?

Thanks for listening.

Evan.