best practice to patch a postgresql version?

Поиск
Список
Период
Сортировка
От qihua wu
Тема best practice to patch a postgresql version?
Дата
Msg-id CAPoYtoLOipP1fUHhAcZYc_D-YE-nreFzMas=F0U_620QsjGMLA@mail.gmail.com
обсуждение исходный текст
Ответы Re: best practice to patch a postgresql version?  (Ron <ronljohnsonjr@gmail.com>)
Список 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?

В списке pgsql-general по дате отправления:

Предыдущее
От: David Goldsmith
Дата:
Сообщение: Re: How to write a crosstab which returns empty row results
Следующее
От: Minh Van Le
Дата:
Сообщение: Sample schemas and data that correlate with all examples in PostgreSQL documentation