RE: Upgrade procedure

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: RE: Upgrade procedure
Date: 2019-11-05 18:09:33
Message-ID: alpine.LNX.2.20.1911051007220.1807@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 5 Nov 2019, Kevin Brannen wrote:

> The manual or others here are more knowledgeable than I, but I believe that
> for a "minor" upgrade, you can just swap out the code and restart PG. For
> major upgrades, the PG server is going to have to come down as the underlying
> files might be changed/transformed during the upgrade, ...

Files might change even with a minor upgrade. The few seconds it takes to
stop, upgrade, and restart the system prevents all errors due to
someone/something accessing the database while it's being upgraded.

Rich

In response to

Browse pgsql-general by date

  From Date Subject
Next Message rihad 2019-11-05 18:12:44 Re: Upgrade procedure
Previous Message Kevin Brannen 2019-11-05 18:05:54 RE: Upgrade procedure