pg_upgrade issue in windows 7

From: "Nithyanantham Shanmugam (nithshan)" <nithshan(at)cisco(dot)com>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: pg_upgrade issue in windows 7
Date: 2019-01-18 19:20:33
Message-ID: E0B12E75-01CB-4DD6-A6B5-3422B06BE680@cisco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Attachment Content-Type Size
pg_upgrade_internal.log application/octet-stream 8.5 KB
pg_upgrade_server_start.log application/octet-stream 1.3 KB

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2019-01-19 08:58:13 BUG #15599: Segfault at MakeExpandedObjectReadOnlyInternal
Previous Message Alvaro Herrera 2019-01-18 18:08:33 Re: BUG #15587: Partitions with ALTER TABLE ADD CONSTRAINT