Re: Trying to ugrade from version 16.2 to 17 - Mailing list pgsql-bugs

From Laurenz Albe
Subject Re: Trying to ugrade from version 16.2 to 17
Date
Msg-id 4b5274a5f60394a58f5f37b24e64079048b7b7a5.camel@cybertec.at
Whole thread Raw
In response to Trying to ugrade from version 16.2 to 17  (Stanley Pagenel <spagenel@exo.quebec>)
Responses RE: Trying to ugrade from version 16.2 to 17
List 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:\ProgramFiles\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éepour 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



pgsql-bugs by date:

Previous
From: Stanley Pagenel
Date:
Subject: Trying to ugrade from version 16.2 to 17
Next
From: PG Bug reporting form
Date:
Subject: BUG #18790: Pg_stat_statements doesn't track schema.