[Info-vax] Status of the PostgreSQL port?

[BillPedersen]

On Sunday, June 28, 2015 at 7:59:46 PM UTC-4, Johann 'Myrkraverk' Oskarsson wrote:
> Hi c.o.vms,
> 
> What is the current status of the PostgreSQL port?  Is the code 
> available somewhere?  Is there anyone actively working on it?
> 
> The latest information I can find is from a year ago, here:
> 
>  
> http://sourceforge.net/p/vms-ports/discussion/portingprojects/thread/6954db7a/
> 
> But I did not come across any source code with a quick google.
> 
> -- 
> Johann                                        | email: invalid -> com
>                                                | www.myrkraverk.com/blog/
> I'm not from the Internet, I just work there. | twitter: @myrkraverk

Johann:

You are correct.  I have not posted the source code up on the VMS-Ports SourceForge Project as I was making reasonable progress until about 15 months ago.  Then various things got in the way.  Time change and I am now getting back to it and getting an environment configured to proceed with additional testing.

One issue is that it depends on unreleased code to support SSIO via code that works with the XFC caching environment and so that means getting others access to that code.  Not a big issue but it is an item that needs to be addressed.

I expect to have an environment up and running again next week where I can then make some progress on testing and get some feedback from others - since it will be accessible on the web as well - on request.

Once things are a little bit further along I will then start to get other people involved as well.

It should be noted that some mentioned that PostgreSQL did not compile on OpenVMS.  Well, that is not strictly true.  It does compile.  But like any other Open Source Port to OpenVMS there are some minor issues to make it compile.  Those are well documented in discussions and presentations on the VMS-Ports project and several other places.  Once any Open Source Port is compiled and linked on OpenVMS then the FUN BEGINS in testing and validating operation.  Some work right away.  Others need some minor adjustment.  Others need some heavy lifting - like PostgreSQL.  But the alternative is major changes in application architecture to support them on OpenVMS.  Thanks to HP OpenVMS Engineering for the initial work on SSIO.  I look forward to continuing to work with them and VSI Engineering as we get this project moving again.

Bill.