Hi Team,
We are hitting an issue during pg_upgrade step (9.5 to 10.6) in couple of windows 7 machines(Enterprise – Service pack 1).
Note: same pg_upgrade step works fine in Windows 10 machines and some of other windows 7 machines.
Attaching the pg_upgrade logs.
Pg_upgrade_internal.log:
-----------------------------------
"C:\Program Files\Software\dbsOld\bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "C:\ProgramData\Software\db\data" -o "-p 5432 -b " start >> "pg_upgrade_server_start.log" 2>&1
*failure*
There were problems executing ""C:\Program Files\Software\dbsOld\bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "C:\ProgramData\Software\db\data" -o "-p 5432 -b " start >> "pg_upgrade_server_start.log" 2>&1"
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 5432?
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 5432?
could not connect to source postmaster started with the command:
"C:\Program Files\Software\dbsOld\bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "C:\ProgramData\Software\db\data" -o "-p 5432 -b “ start
On examining pg_upgrade logs, seems like old db server couldn’t start for some reason. From the logs, couldn’t find the reason why source server couldn’t be started.
Pg_upgrade_server_start.log:
-----------------------------------------
command: "C:\Program Files\Software\dbsOld\bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "C:\ProgramData\Software\db\data" -o "-p 5432 -b " start >> "pg_upgrade_server_start.log" 2>&1
waiting for server to start.... stopped waiting
pg_ctl: could not start server
Could you please help on this. Are there any other debugging steps to further root cause the pg_upgrade failure in the windows 7 machine.
Thanks,
Nithya
