Thread: Trying to ugrade from version 16.2 to 17

Trying to ugrade from version 16.2 to 17

From
Stanley Pagenel
Date:
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

I am using this command 🙂

"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"


Exécution de tests de cohérence
-------------------------------
Checking cluster versions                                     ok
Checking database user is the install user                    ok
Checking database connection settings                         ok
Checking for prepared transactions                            ok
Checking for contrib/isn with bigint-passing mismatch         ok
Checking data type usage                                      ok
Creating dump of global objects                               ok
Creating dump of database schemas
                                                              ok

la connexion au serveur sur « localhost » (::1), port 50432 a échoué : FATAL:  authentification par mot de passe échouée pour l'utilisateur  « postgres »


n'a pas pu se connecter au postmaster cible lancé avec la commande :
"E:/Program Files/PostgreSQL/17/bin/pg_ctl" -w -l "E:/Program Files/PostgreSQL/17/data/pg_upgrade_output.d/20250128T143140.774/log/pg_upgrade_server.log" -D "E:/Program Files/PostgreSQL/17/data" -o "-p 50432 -b -c synchronous_commit=off -c fsync=off -c full_page_writes=off -c max_slot_wal_keep_size=-1 " start
Échec, sortie

Thanks,

Stanley