Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1teuw3-00GMW9-5h for pgsql-advocacy@arkaria.postgresql.org; Mon, 03 Feb 2025 11:48:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1teuw2-00CriY-7W for pgsql-advocacy@arkaria.postgresql.org; Mon, 03 Feb 2025 11:48:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1teuw1-00CriP-V2 for pgsql-advocacy@lists.postgresql.org; Mon, 03 Feb 2025 11:48:14 +0000 Received: from mail-pj1-x102f.google.com ([2607:f8b0:4864:20::102f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1teuvy-0031jJ-1b for pgsql-advocacy@lists.postgresql.org; Mon, 03 Feb 2025 11:48:13 +0000 Received: by mail-pj1-x102f.google.com with SMTP id 98e67ed59e1d1-2ee46851b5eso5411353a91.1 for ; Mon, 03 Feb 2025 03:48:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1738583288; x=1739188088; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=IB7YJZCsEPyFkU+B2ulH5OEzNfw6yM+lQLdmrhB5oJw=; b=gWOkxBE1pR+R0kmi185RNWhY4qQsWomF25A/ils5O65V/+cp/SHG3j9znaqviVk3Io 0Yf5iQpVnjs5uh+Pm15a1Qh28gZVdxrDemz2b5Ylpa1zu8mMY76bN738NN9saNohoHG3 NdmmO9TrummdX4SQnmy4p9OxLGxpHRO7Ddik1xu/lCGd4IpawXCCcaDXV3zmd6TgOk0F odXIq0NRg9eEIykc3BArpxAkEdfKXN+C7fDRhiUdp+Y1F94tTUuYzzH/qLKBretNT0El DF706IIeELDpd27Ps6ndrafdsfw1jfq+bXHVfxAWsl3GZbP0Fvb/d5KqQA6dyynkvw9u XJ+w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1738583288; x=1739188088; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=IB7YJZCsEPyFkU+B2ulH5OEzNfw6yM+lQLdmrhB5oJw=; b=mGKo/AyHiB67HfTjafj9ki7tEE1vpKCgrjZsPD9IH2aPwY2/UizoDeTpBKBSWuyiAe 9odKJthoybAJoXcZZ/IH7BWjJbmanLyk2qU1hZRp0GFIdMl6HxpGGbOjIZWbCT9Ktazi ACzO2jPeiDBiB1gHu10l3bKPsm+Rnx3iQoNj+0xvLzmOJjiSfYfqbHx4g1l5vDNodx9N bsIOaHWiTViKroV9FDPThQrkpKuHjwKdEQqaj2heJQUVyZGqLatuY06d7Q19zcMdmN3y I/sYv8FDrWb4GBToDgm0T/c7hWeMDCmIG6n7KyN/qFYnvNU69thIASVxF40cAc3AMwrX PyGA== X-Forwarded-Encrypted: i=1; AJvYcCWQTx5sWbgNr/PM0AYVvBXiNgXKFM53XC3dTP93ZzrxE+qGd6x/Kydy3pBxKDuD6k3Slcvjcjo0QozjjQ1ihQ==@lists.postgresql.org X-Gm-Message-State: AOJu0YxsFl8/dAENIYC4pyDVAlFV0TnCr1wXASSvRJGmnYE76jmbxHOa +oJ46NAy9olQKzScensV6cWp29bLx6GJkz4AU04LL/xXUgSZg1i9mqahv5FlFusE8atxyL17rQI WQ++fHbKAmqfubYETCo9CtCk8JNOMtg== X-Gm-Gg: ASbGncubf/hdOqAHMrhL4twTyyk6LoiXMxKUioejlcsdhTEOKw1+B2NuLjS5ukwiYkc lFBEcfJMwheRaY0EJpRQ3j0PLz5ozOenEChjVbNSaJoCp8xxfQ1qVIcYSSPyjx6HxerMDlb466N aCooHdzZBI6KDQrCc727BoSxMAScypa0g= X-Google-Smtp-Source: AGHT+IFGoI1RGPEumjO+E7xgqDC3m/XCJ+kWxLBj81+PAVquIkQ01VpxY3QGDuuhGi/nDcWFhXKtkKhO4QE1ezZpNS0= X-Received: by 2002:a17:90b:1f90:b0:2ee:3cc1:793b with SMTP id 98e67ed59e1d1-2f83ac5e4d6mr27609141a91.26.1738583288068; Mon, 03 Feb 2025 03:48:08 -0800 (PST) MIME-Version: 1.0 References: <551181.1737756577@sss.pgh.pa.us> <49df303f741ce4a12a4ab757742eed0e@postgresql.org> In-Reply-To: <49df303f741ce4a12a4ab757742eed0e@postgresql.org> From: Vish Penmetsa Date: Mon, 3 Feb 2025 17:17:55 +0530 X-Gm-Features: AWEUYZkqtxbXk1Ts8sg4h6RjsT5-eedBwSwYWAdYSq9BTOceURJinL_3Ch7IwT4 Message-ID: Subject: Re: PostgreSql and VMS operating System To: Justin Clift Cc: Tom Lane , Bruce Momjian , Christophe Pettus , Daniel Gustafsson , pgsql-advocacy@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000004c4334062d3b776e" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000004c4334062d3b776e Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Unix is a programmer's operating system and obviously programmes like it. About VMS there is a bit of history that Bill Gates from Microsft had hired Bill Cutler from the VMS Team to build Windows operating system. And obviously at that time the focus was more on Windows interfaces rather than the VMS like OS which was more of a server. And when it comes to PostgreSQl whe will be really loking at the server side of things rather than it's user interface capabilities where one migth Windows to be far more useful and easy. DEC had lost of the following Industry leading Advantages - DECNet -> TCP/I= P OSF - Linux Alpha architecture - Everyone caught up with 64 bit chips while DEC Alpha was the first 64 bit chip. Cluster Architecture -> Oracle & RAC & Unix And in all these we have'n t looked at the core strengths of how the operating system was built for server operations. Probably one has to start with the assumption that it is somehow extremely good and try your best to prove it. One example I could give as to why I am keen on VMS is something about the OS learning about exeutable images to make the startup fast. Then coming to teh user accounts there is something abour working sets for tuning and these were advatages when you were talking about 32 MB of memory or 64 MB of memory for large no of users rather than 32 GB or 64 GB for few uers ( I have 32 GB on my Windows PC just for myself) Then there will be more. On Mon, Feb 3, 2025 at 3:54=E2=80=AFPM Justin Clift = wrote: > On 2025-01-25 08:09, Tom Lane wrote: > > Bruce Momjian writes: > >> On Fri, Jan 24, 2025 at 01:07:56AM -0800, Christophe Pettus wrote: > >>> So, basically, if you want a maintained VMS port, you need to either > >>> drive the project yourself, or find others who will. > > > >> This email thread from 2003 says VMS probably doesn't work anymore > >> because of lack of testers: > >> > https://www.postgresql.org/message-id/flat/200301071531.h07FVWI08147%40ca= ndle.pha.pa.us#0dbc1439f51ec7842125fb8ae200b6da > > > > I doubt we ever had a working VMS port. There are precisely zero > > references to VMS in our commit log, so certainly there was never one > > that got removed. It's barely possible that PG "just worked" without > > any patches under their POSIX emulation layer, but I could not find > > any indication of successful users of PG-on-VMS in the mail list > > archives either. > > As a data point, when the recent incarnation of VMS Software announced > their intention to allow Community sign ups a few years ago, I went > and created an account on their system to investigate. VAX VMX being > one of the first multi-user systems I learned back in the day, before > learning *nix. ;) > > Anyway, it went... poorly. Their system is so crap that users can only > have a very specific set of "special" characters allowedin user > passwords: > > $#@!%*& > > Any other symbols are accepted at password setting time, but actually > cause the user login to fail. > > When I attempted to file a bug about this problem, they literally told > me it's not a bug and it working as intended. > > So frankly, VMS Software are so completely clueless that I strongly > recommend no-one waste their time and effort on them. > > Regards and best wishes, > > Justin Clift > --0000000000004c4334062d3b776e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Unix is a programmer's operating system and obviously = programmes like it.

About VMS there is a bit of history = that Bill Gates from Microsft=C2=A0had hired Bill Cutler from the VMS Team = to build Windows operating system.

And obviously a= t that time the focus was more on Windows interfaces rather than the VMS li= ke OS which was more of a server.

And when it come= s to PostgreSQl whe will be really loking=C2=A0at the server side of things= rather than it's user interface capabilities where one migth=C2=A0Wind= ows to be far more=C2=A0
useful and easy.

DEC had lost of the following Industry leading Advantages - DECNet -> = TCP/IP
OSF - Linux
Alpha architecture - Everyone caught= up with 64 bit chips while DEC Alpha was the first 64 bit chip.
= Cluster Architecture -> Oracle & RAC & Unix

=
And in all these we have'n t looked at the core strengths of how t= he operating system was built for server operations.

Probably one has to start with the assumption that it is somehow extreme= ly good and try your best to prove it.

One example= I could give as to why I am keen on VMS is something about the OS learning= about exeutable images to make the startup fast.

= Then coming to teh=C2=A0user accounts there is something abour=C2=A0working= sets for tuning and these were advatages when you were talking about 32 MB= of memory or 64 MB of memory=C2=A0
for large no of users rather = than 32 GB or 64 GB for few uers=C2=A0( I have 32 GB on my Windows PC just = for myself)

Then there will be more.=C2=A0

On Mon, Feb 3, 2025 at 3:54=E2=80=AFPM Justin Clift <= ;justin@postgresql.org> wro= te:
On 2025-01-2= 5 08:09, Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
>> On Fri, Jan 24, 2025 at 01:07:56AM -0800, Christophe Pettus wrote:=
>>> So, basically, if you want a maintained VMS port, you need to = either
>>> drive the project yourself, or find others who will.
>
>> This email thread from 2003 says VMS probably doesn't work any= more
>> because of lack of testers:
>>=C2=A0 =C2=A0 =C2=A0 https://www.postgresql.org= /message-id/flat/200301071531.h07FVWI08147%40candle.pha.pa.us#0dbc1439f51ec= 7842125fb8ae200b6da
>
> I doubt we ever had a working VMS port.=C2=A0 There are precisely zero=
> references to VMS in our commit log, so certainly there was never one<= br> > that got removed.=C2=A0 It's barely possible that PG "just wo= rked" without
> any patches under their POSIX emulation layer, but I could not find > any indication of successful users of PG-on-VMS in the mail list
> archives either.

As a data point, when the recent incarnation of VMS Software announced
their intention to allow Community sign ups a few years ago, I went
and created an account on their system to investigate.=C2=A0 VAX VMX being<= br> one of the first multi-user systems I learned back in the day, before
learning *nix. ;)

Anyway, it went... poorly.=C2=A0 Their system is so crap that users can onl= y
have a very specific set of "special" characters allowedin user <= br> passwords:

=C2=A0 =C2=A0$#@!%*&

Any other symbols are accepted at password setting time, but actually
cause the user login to fail.

When I attempted to file a bug about this problem, they literally told
me it's not a bug=C2=A0and it working as intended.

So frankly, VMS Software are so completely clueless that I strongly
recommend no-one waste their time and effort on them.

Regards and best wishes,

Justin Clift
--0000000000004c4334062d3b776e--