Re: Trying to ugrade from version 16.2 to 17

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Stanley Pagenel <spagenel(at)exo(dot)quebec>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Trying to ugrade from version 16.2 to 17
Date: 2025-01-29 16:29:51
Message-ID: 4b5274a5f60394a58f5f37b24e64079048b7b7a5.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, 2025-01-29 at 14:20 +0000, Stanley Pagenel wrote:
> Hello,  can you help me with this error I am receiving when I am trying to do the upgrade from version 16.2  to 17.0
>
> "E:\Program Files\PostgreSQL\17\bin\pg_upgrade.exe" --old-datadir "E:\Program Files\PostgreSQL\16\data" --new-datadir "E:\Program Files\PostgreSQL\17\data" --old-bindir "E:\Program Files\PostgreSQL\16\bin" --new-bindir "E:\Program Files\PostgreSQL\17\bin"
>
> la connexion au serveur sur « localhost » (::1), port 50432 a échoué : FATAL:  authentification par mot de passe échouée pour l'utilisateur  « postgres »

Your v17 server does not allow password-less local connections.

Either adjust its "pg_hba.conf" to allow such connections or create a password
file for the connection:
https://www.postgresql.org/docs/current/libpq-pgpass.html

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2025-01-29 19:10:33 BUG #18790: Pg_stat_statements doesn't track schema.
Previous Message Stanley Pagenel 2025-01-29 14:20:05 Trying to ugrade from version 16.2 to 17