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