best practice to patch a postgresql version?

From: qihua wu <staywithpin(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: best practice to patch a postgresql version?
Date: 2022-12-26 09:29:11
Message-ID: CAPoYtoLOipP1fUHhAcZYc_D-YE-nreFzMas=F0U_620QsjGMLA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We are planning to use postgresq on production, but there is one question
about how to patch a db. We don't want to overwrite the old version
directly, so that we can rollback if the new version has issues. So we
want to install it a different location such as /home/postgres/14.1 for
version 14.1 (all binary should be under 14.1 or sub-fold of 14.1) and
/home/postgres/14.0 for 14.0, in this way we can easily switch between
different versions. But apt install on ubuntu doesn't have the option for a
customized location. So what's the best practice to patch postgres?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Minh Van Le 2022-12-26 11:03:48 Sample schemas and data that correlate with all examples in PostgreSQL documentation
Previous Message David Goldsmith 2022-12-25 16:57:47 Re: How to write a crosstab which returns empty row results