RE: BUG #19392: PG_UPGRADE is non-functional on Windows

From: Jeff Laing <jeff(dot)laing(at)spatialnetworx(dot)ai>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: PostgreSQL Bug List <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: RE: BUG #19392: PG_UPGRADE is non-functional on Windows
Date: 2026-02-05 02:57:13
Message-ID: DU0PR02MB8220F9DF6D0CDCCBE5F7F30D8F99A@DU0PR02MB8220.eurprd02.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

>> From: David G. Johnston david(dot)g(dot)johnston(at)gmail(dot)com<mailto:david(dot)g(dot)johnston(at)gmail(dot)com>
>> Sent: Thursday, 5 February 2026 10:39 AM
>>
>> Postmaster is the name of the executable that is the server program.

Perhaps on Unix, but I don’t think it is on Windows?

C:> netstat -abo

TCP 0.0.0.0:5432 SPNX-1Z2SRV3:0 LISTENING 39060
[postgres.exe]

I can see that the “directory structure” has mentions of “postmaster”

[13:50:24.50 C:\postgresql18]
C:> dir/s/b postmaster*
C:\postgresql18\data\postmaster.opts
C:\postgresql18\data\postmaster.pid
C:\postgresql18\include\server\postmaster
C:\postgresql18\include\server\postmaster\postmaster.h

… but on windows, that’s not visible in the pathname of the executable.

[13:52:20.45 C:\postgresql18]
C:> dir/s/b postgres.exe
C:\postgresql18\bin\postgres.exe

Again, only an issue because in a past life, “postmaster” was a different user-id used by a completely different application, so it’s not critical, it’s just misled and sent me down the wrong blind alley.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2026-02-05 04:23:25 Re: BUG #19392: PG_UPGRADE is non-functional on Windows
Previous Message David G. Johnston 2026-02-04 23:38:46 Re: BUG #19392: PG_UPGRADE is non-functional on Windows