how to manage automatic updates

From: Evan Rempel <erempel(at)uvic(dot)ca>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: how to manage automatic updates
Date: 2018-01-03 18:39:35
Message-ID: d2214ea8-08f2-0554-95e0-c54c72bb41c7@uvic.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Kerber 2018-01-03 18:50:50 Re: how to manage automatic updates
Previous Message Tom Lane 2018-01-03 16:59:39 Re: pt_toast table seems to be