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

public inbox for [email protected]  
help / color / mirror / Atom feed

From: Jeff Laing <[email protected]>
To: David G. Johnston <[email protected]>
Cc: PostgreSQL Bug List <[email protected]>
Subject: RE: BUG #19392: PG_UPGRADE is non-functional on Windows
Date: Thu, 5 Feb 2026 02:57:13 +0000
Message-ID: <DU0PR02MB8220F9DF6D0CDCCBE5F7F30D8F99A@DU0PR02MB8220.eurprd02.prod.outlook.com> (raw)
In-Reply-To: <CAKFQuwba0jCCNAZhi5jYc9pbVv0FWq7gAVTdz6QbaVFTpTjFTw@mail.gmail.com>
References: <[email protected]>
	<CAKFQuwYb54KmC3LXzOVsHNcGht8QqfekVFouza=hj6J7ny=yWA@mail.gmail.com>
	<[email protected]>
	<DU0PR02MB822060E185DE9DB06AAC351A8F98A@DU0PR02MB8220.eurprd02.prod.outlook.com>
	<CAKFQuwba0jCCNAZhi5jYc9pbVv0FWq7gAVTdz6QbaVFTpTjFTw@mail.gmail.com>

>> From: David G. Johnston [email protected]<mailto:[email protected]>
>> 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.

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: RE: BUG #19392: PG_UPGRADE is non-functional on Windows
  In-Reply-To: <DU0PR02MB8220F9DF6D0CDCCBE5F7F30D8F99A@DU0PR02MB8220.eurprd02.prod.outlook.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox