Sample Header Ad - 728x90

Upgrading Postgres 12 to 13: 'pg_upgrade.exe' fails

1 vote
1 answer
2071 views
I'm attempting to upgrade a Postgres instance from version 12 to version 13, following the steps outlined at https://www.postgresql.org/docs/13/pgupgrade.html . From an elevated command prompt, I'm running (under Windows 10): > SET PATH=%PATH%;C:\Program Files\PostgreSQL\13\bin; > > pg_upgrade.exe --old-datadir "E:\Programs\PostgreSQL\12\data" > --new-datadir "E:\Programs\PostgreSQL\13\data" --old-bindir "C:\Program Files\PostgreSQL\12\bin" --new-bindir "C:\Program > Files\PostgreSQL\13\bin" --old-port=5431 --new-port=5432 --jobs=5 The directories appear to be all correct, however the command returns: >
> Performing Consistency Checks  
> -----------------------------  
> Checking cluster versions                                   ok  
>   
> *failure*  
> Consult the last few lines of "pg_upgrade_server_start.log" or "pg_upgrade_server.log" for  
> the probable cause of the failure.  
>   
> connection to database failed: could not connect to server: Connection refused (0x0000274D/10061)  
>         Is the server running on host "localhost" (::1) and accepting  
>         TCP/IP connections on port 5431?  
> could not connect to server: Connection refused (0x0000274D/10061)  
>         Is the server running on host "localhost" (127.0.0.1) and accepting  
>         TCP/IP connections on port 5431?  
>   
> could not connect to source postmaster started with the command:  
> "C:/Program Files/PostgreSQL/12/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "E:/Programs/PostgreSQL/12/data" -o "-p 5431 -b " start  
> Failure, exiting  
>
pg_upgrade_server_start.log says: > command: "C:/Program Files/PostgreSQL/12/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "E:/Programs/PostgreSQL/12/data" -o "-p 5431 -b " start >> "pg_upgrade_server_start.log" 2>&1 > The program "postgres" was found by "C:/Program Files/PostgreSQL/12/bin/pg_ctl" > but was not the same version as pg_ctl. > Check your installation. I'm at a loss; what might be wrong, and how can I successfully perform this procedure?
Asked by Marc.2377 (187 rep)
Mar 10, 2021, 09:24 PM
Last activity: Apr 21, 2024, 08:45 PM