| 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: | Whole Thread | Raw Message | 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 |