From: Olivier Cherrier <oc@symacx.com>
Subject: Re: databases/postgresql : README-server patch
To: Jeremy Evans <jeremy@openbsd.org>, ports@openbsd.org
Date: Wed, 8 Jul 2026 18:04:31 +0200

On 7/8/26 5:33 PM, Jeremy Evans wrote:
> On 07/08 11:15, Stuart Henderson wrote:
>> On 2026/07/08 10:26, Olivier Cherrier wrote:
>>> ??? Hello,
>>>
>>> While upgrading using method 1 (dump / restore),
>>> the 'postgresql-pg_upgrade' pkg is not installed.
>>>
>>> Please see attached patch.
>>> @@ -120,7 +120,7 @@ Examine your old file for local changes
>>>   (/var/postgresql/data/postgresql.conf). The following command may help
>>>   identify them:
>>>   
>>> -# diff -wu ${LOCALBASE}/share/postgresql-${PREV_MAJOR}/postgresql.conf.sample \
>>> +# diff -wu ${LOCALBASE}/share/postgresql/postgresql.conf.sample \
>>>       /var/postgresql/data-${PREV_MAJOR}/postgresql.conf
>> It's probably better to install postgresql-pg_upgrade. This will allow
>> comparing the live config file against a default one with fewer
>> differences as it's from a more similar version. e.g.
> I don't think we should recommend pg_upgrade in the non-pg_upgrade case.
> I think we should move the configuration difference instructions before
> pkg_add -ui. Then we don't need pg_upgrade. What are your thoughts on
> that?
>

+1

Thanks,
oc