From: David Fetter on
On Tue, Feb 16, 2010 at 12:39:29PM -0500, Rayson Ho wrote:
> On Tue, Feb 16, 2010 at 11:22 AM, David Fetter wrote:
> > � �* Shell access from several accounts
> > � �* Git or cvs client
> > � �* Compiler tools
> > � �* Perl of a fairly recent vintage
> > � �* Outbound http access
>
> I had access to the HP testdrive before they closed it down (the
> Unix servers were down in Sept 08, but the VMS cluster was running
> till Jan 2010). They blocked all outbound internet access to the
> testdrive servers -- only telnet and ftp were allowed.

Outbound http access is for the buildfarm, which is pretty important
to how we develop.

> Count me in for the OpenVMS porting effort (but I guess I will apply
> for an account seperately as I might port other things to OpenVMS in
> the future). I believe the porting effort is larger than a new Unix
> port but smaller than the Windows port, as most of the Unix and
> POSIX functions and system calls are supported on OpenVMS.

You clearly know vastly more than I do about this, and should lead
this effort :)

> Lastly, are we going to support ODS-2 disks?? And are we going to
> require GNV installed for building and running PostgreSQL on
> OpenVMS??

You tell us :)

Cheers,
David.
--
David Fetter <david(a)fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter(a)gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

--
Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

From: "Dann Corbit" on
> -----Original Message-----
> From: pgsql-hackers-owner(a)postgresql.org [mailto:pgsql-hackers-
> owner(a)postgresql.org] On Behalf Of Rayson Ho
> Sent: Tuesday, February 16, 2010 9:39 AM
> To: David Fetter
> Cc: Andrew Dunstan; PG Hackers
> Subject: Re: [HACKERS] OpenVMS?
>
> On Tue, Feb 16, 2010 at 11:22 AM, David Fetter wrote:
> >    * Shell access from several accounts
> >    * Git or cvs client
> >    * Compiler tools
> >    * Perl of a fairly recent vintage
> >    * Outbound http access
>
> I had access to the HP testdrive before they closed it down (the Unix
> servers were down in Sept 08, but the VMS cluster was running till Jan
> 2010). They blocked all outbound internet access to the testdrive
> servers -- only telnet and ftp were allowed.
>
> Count me in for the OpenVMS porting effort (but I guess I will apply
> for an account seperately as I might port other things to OpenVMS in
> the future). I believe the porting effort is larger than a new Unix
> port but smaller than the Windows port, as most of the Unix and POSIX
> functions and system calls are supported on OpenVMS.
>
> MySQL has around 10 functions changed or written specifically for
> OpenVMS, most of those are related to utime(), $UMASK & $UMASKDIR,
> open(), and Unix pathnames. (I think utime() support was added a few
> years ago to OpenVMS 7.3 & 8.0 -- so may be the code was added to
> MySQL for earlier VMS versions.)
>
> PostgreSQL uses fork(), which is not supported on OpenVMS. However,
> the techniques used by the WIN32 version of internal_forkexec() in
> src/backend/postmaster/postmaster.c give the VMS version a good
> starting point.

For PostgreSQL, you will probably want to use LIB$SPAWN() as a rough equivalent to CreateProcess() on Windows
http://www.sysworks.com.au/disk$vaxdocsep002/opsys/vmsos721/5932/5932pro_041.html

> Lastly, are we going to support ODS-2 disks?? And are we going to
> require GNV installed for building and running PostgreSQL on OpenVMS??


--
Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

From: Bruce Momjian on
Dann Corbit wrote:
> > PostgreSQL uses fork(), which is not supported on OpenVMS. However,
> > the techniques used by the WIN32 version of internal_forkexec() in
> > src/backend/postmaster/postmaster.c give the VMS version a good
> > starting point.
>
> For PostgreSQL, you will probably want to use LIB$SPAWN() as a rough equivalent to CreateProcess() on Windows

Ah, LIB$SPAWN, that brings back memories.

> http://www.sysworks.com.au/disk$vaxdocsep002/opsys/vmsos721/5932/5932pro_041.html
>
> > Lastly, are we going to support ODS-2 disks?? And are we going to
> > require GNV installed for building and running PostgreSQL on OpenVMS??

I hate to pour cold water on this, but why is it worth adding support
for a platform that has such marginal usage.

--
Bruce Momjian <bruce(a)momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

--
Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

From: Rayson Ho on
On Tue, Feb 16, 2010 at 2:56 PM, Dann Corbit wrote:
> For PostgreSQL, you will probably want to use LIB$SPAWN() as a rough equivalent to CreateProcess() on Windows

We will need to support running PostgreSQL as a detached process, and
thus it won't have access to the DCL CLI. The implication is that
lib$spawn or system() will fail when used this way.

http://labs.hoffmanlabs.com/node/794

So we will likely need to use sys$creprc() in internal_forkexec().

Rayson



> http://www.sysworks.com.au/disk$vaxdocsep002/opsys/vmsos721/5932/5932pro_041.html
>
>> Lastly, are we going to support ODS-2 disks?? And are we going to
>> require GNV installed for building and running PostgreSQL on OpenVMS??
>
>

--
Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

From: "Marc G. Fournier" on
On Tue, 16 Feb 2010, Bruce Momjian wrote:

> I hate to pour cold water on this, but why is it worth adding support
> for a platform that has such marginal usage.

Because someone feels like dedicating their resources to it ... ?

----
Marc G. Fournier Hub.Org Hosting Solutions S.A.
scrappy(a)hub.org http://www.hub.org

Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:scrappy(a)hub.org

--
Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers