Re: Need Help On Upgrade

Hello KK,

In the beginning, it was a little challenging, but as the process went on
it became easy. No, it was not a multistage upgrade. It was possible to
upgrade straight from 9.5 to 14.

We did not change anything on the schema. For data type, we alter all
tables that were created with OIDs to remove the OIDs. We remove all data
with abs time ( absolute time). We equally remove all data with
sql_identifier. We also created a script to check for unknown data type and
another to remove them.

For documentation, we did not use any specific documentation. We just
followed postgresql documentation on upgrading. We created our one plan
and steps based on our clusters, ensuring we can safely roll back in case
of any challenges.

Thank you.
Johnathan T

On Tue, Jul 11, 2023 at 5:17 AM KK CHN <kkchn(dot)in(at)gmail(dot)com> wrote:

> Hi Johnathan,
>
> 1. How complex was it upgrading from an old Postgres 9.5 to 14.8 ? Is it
> multistage upgrading or single shot to 14.8 ?
>
> 2. What about the old schema ( data types of 9.8 when the database was
> designed couple of years ago? and the datatypes supported in 14.8 is
> there any manual work was involved in this migration , please let me know
> the manual works needed to perform while migration from 9.8 to 14.8)
>
> 3. Which documentation needs to be followed to perform this upgrade ??
>
> Any hints much appreciated..
> Krishane
>
> On Mon, Jul 10, 2023 at 11:46 PM Johnathan Tiamoh <
> johnathantiamoh(at)gmail(dot)com> wrote:
>
>> Hello,
>>
>> I upgraded from postgresql 9.5 to 14.8. After the upgrade users were not
>> able to connect due to password hash.
>>
>> The password encryption was on scram-sha-256. The password hash was on
>> md5. in the pg_hba.conf file the authentication method was md5. I do not
>> know why users could not connect because as per postgresql documentation,
>> that should work.
>>
>> I have previously done a similar upgrade and did not face similar issues.
>>
>>
>> Kind regards
>> Johnathan Tiamoh
>>
>