Re: [HACKERS] PostgreSQL on Novell Netware 6.5.
They stopped at 7.2.4 because they're finishing some usefull APIs, which'll make the port much more easy. Will this involve using a Linux kernel ;) :) No, a NW kernel with a POSIX library. This'll be great, because :you'll can run powerfull opensource software with an enterprise-class NOS. Another option... Well, the pthreads seem to be working just fine. For all my work that most people would do in C/C++, I do in assembler, and the POSIX support in NetWare now is providing some very nice APIs in NetWare 6.0 and 6.5 that simply weren't available on NetWare 4.x and earlier (NetWare 5.x has some of this, and Novell has been working hard to move in this direction). Clustering support (32 x 32), stable consistent file system (Novell's Storage System, forget the old Tradition File System (very mature stable, but it doesn't fit the current storage necessity)), security stability (our servers is counting 700+ days). I hosted over 500 internet sites (HTTP (Apache), DNS, SMTP/POP3, FTP, NNTP, Oracle, various Java services, PERL, etc.) on NetWare 5 across two different /24 address spaces, and the server (yes, all of this was done with a single Pentium III server with 512 MBs of RAM) was fast and reliable with minimal maintenance. The new file system (NSS) cuts down the boot time since volume mounts always complete in less than 1 second as opposed to the Traditional File System (TFS) which required approximately 5 to 10 minutes to mount. NSS is a journaling system, which I've not been able to break yet by simulating power outages during busy times. When the next release of PostgreSQL is ready for NetWare, I'm going to try to break it in this way as well (by making it very busy with many simultaneous write, index, and vacuum operations before pulling the plug). So far I've found that Oracle 8i on NetWare was quite good at handling this and the worst that ever happened (at least in my testing) was that there was a cut-off point where newly written records were lost. I'm not pleased with Oracle's decision to discontinue support for NetWare, and PostgreSQL fits that void very well (except for not having table spaces, but I can live with that), and so I anxiously await the new version of PostgreSQL so that I can proceed with some rather large web- based projects that have been in the planning and research stages for approximately 3 years now. Unfortunately I simply can't use MySQL because they don't have views, and there are some data integrity problems (e.g., numbers getting truncated silently instead of an error being returned, etc.). It's a valuable addition to the Novell community, but it's also an good addition to the PostgreSQL community, but of course, when everything is 100% done. ;) I agree wholeheartedly that both the Novell and PostgreSQL user and developer communities will benefit greatly from this. From a marketing perspective, both organizations will also benefit by gaining additional exposure. -- Randolf Richardson - [EMAIL PROTECTED] Vancouver, British Columbia, Canada Please do not eMail me directly when responding to my postings in the newsgroups. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] PostgreSQL on Novell Netware 6.5.
They stopped at 7.2.4 because they're finishing some usefull APIs, which'll make the port much more easy. Will this involve using a Linux kernel ;) :) No, a NW kernel with a POSIX library. This'll be great, because you'll can run powerfull opensource software with an enterprise-class NOS. Another option... Clustering support (32 x 32), stable consistent file system (Novell's Storage System, forget the old Tradition File System (very mature stable, but it doesn't fit the current storage necessity)), security stability (our servers is counting 700+ days). It's a valuable addition to the Novell community, but it's also an good addition to the PostgreSQL community, but of course, when everything is 100% done. ;) Regards, Eduardo ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [HACKERS] PostgreSQL on Novell Netware 6.5.
They stopped at 7.2.4 because "they're finishing some usefull APIs, which'll make the port much more"easy"." When this part is done, a new port will be made with 7.4. With much less "NetWare specific code" and maybe, it'll be "accepted" by the PostgreSQL community. Regards, Eduardo
Re: [HACKERS] PostgreSQL on Novell Netware 6.5.
Eduardo D Piovesam kirjutas E, 20.10.2003 kell 16:35: They stopped at 7.2.4 because they're finishing some usefull APIs, which'll make the port much more easy. Will this involve using a Linux kernel ;) When this part is done, a new port will be made with 7.4. With much less NetWare specific code and maybe, it'll be accepted by the PostgreSQL community. Sure! Hannu ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [HACKERS] PostgreSQL on Novell Netware 6.5.
Why 7.2.4 I wonder? And I don't see anything there in the CVS repository. I know they are not obliged to show us the source code, but doing so would be nice (especially to see the threading part). Hi Andrew, here you have the source code: http://forge.novell.com/modules/xfmod/project/showfiles.php?group_id=1132release_id=434 Greetings.. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] PostgreSQL on Novell Netware 6.5.
"Eduardo D Piovesam" [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... Hi, It's been quite a while ago that I did NetWare programming (3.11 NLM, communication protocol for a dbms), and that I had some contact with Netware (4.1), but if Novell didn't change the architecture completely (I doubt that) the native win32 port won't be of any help for They've done the job. Forget all about 3.x / 4.x and even 5.x. No more CLib, you have now LibC which is a POSIX like API. AFAIK, they're finishing some usefull APIs, which'll make the port much more "easy". The "only difference" will be the "threaded model" instead of process based... NW6.x already have Apache, bash, gcc, mysql, openssh, vnc, etc... thanks to this "new architecture". You can get the 7.2.4 on http://forge.novell.com Why 7.2.4 I wonder? And I don't see anything there in the CVS repository. I know they are not obliged to show us the source code, but doing so would be nice (especially to see the threading part). cheers andrew
Re: [HACKERS] PostgreSQL on Novell Netware 6.5.
Hi, It's been quite a while ago that I did NetWare programming (3.11 NLM, communication protocol for a dbms), and that I had some contact with Netware (4.1), but if Novell didn't change the architecture completely (I doubt that) the native win32 port won't be of any help for They've done the job. Forget all about 3.x / 4.x and even 5.x. No more CLib, you have now LibC which is a POSIX like API. AFAIK, they're finishing some usefull APIs, which'll make the port much more easy. The only difference will be the threaded model instead of process based... NW6.x already have Apache, bash, gcc, mysql, openssh, vnc, etc... thanks to this new architecture. You can get the 7.2.4 on http://forge.novell.com Eduardo ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[HACKERS] PostgreSQL on Novell Netware 6.5.
Hello all, I have seen this presentation for new Novell Netware 6.5 version released about two weeks or so. http://www.novell.com/products/netware/netware65overview_popup.html If you check 'Open Source' point, PostgreSQL text and PostgreSQL logo are showed on the run. I would be very happy if we could run PostgreSQL on Novell Netware environment instead of Oracle or MySQL (default database on this novell OS version) in a near future. Somebody know if the changes to run PostgreSQL on Win32 platform will be provide a easiest port for Novell Netware servers ? Thanks a lot. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] PostgreSQL on Novell Netware 6.5.
Terry Yapt wrote: Hello all, I have seen this presentation for new Novell Netware 6.5 version released about two weeks or so. http://www.novell.com/products/netware/netware65overview_popup.html If you check 'Open Source' point, PostgreSQL text and PostgreSQL logo are showed on the run. I would be very happy if we could run PostgreSQL on Novell Netware environment instead of Oracle or MySQL (default database on this novell OS version) in a near future. Somebody know if the changes to run PostgreSQL on Win32 platform will be provide a easiest port for Novell Netware servers ? It's been quite a while ago that I did NetWare programming (3.11 NLM, communication protocol for a dbms), and that I had some contact with Netware (4.1), but if Novell didn't change the architecture completely (I doubt that) the native win32 port won't be of any help for implementing PostgreSQL on NetWare. It's very different from Windows and *ix, so it would be a complete third implementation of basic service interfacing. Regards, Andreas ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] PostgreSQL on Novell Netware 6.5.
On Sun, Sep 14, 2003 at 10:52:58PM +0200, Andreas Pflug wrote: Terry Yapt wrote: I have seen this presentation for new Novell Netware 6.5 version released about two weeks or so. http://www.novell.com/products/netware/netware65overview_popup.html If you check 'Open Source' point, PostgreSQL text and PostgreSQL logo are showed on the run. It's been quite a while ago that I did NetWare programming (3.11 NLM, communication protocol for a dbms), and that I had some contact with Netware (4.1), but if Novell didn't change the architecture completely (I doubt that) the native win32 port won't be of any help for implementing PostgreSQL on NetWare. It's very different from Windows and *ix, so it would be a complete third implementation of basic service interfacing. Some time ago there was a guy from Novell posting on hackers about the porting of PostgreSQL to Netware. He sounded like most of the job was already done, but he wanted to have some patches accepted to be able to build with a toolchain different from GNU make and friends (because it was one or two orders of magnitude faster). He left some time later because of the null support he received for that, it seems. Some time after that, Novell announced that MySQL would be their default database system ... -- Alvaro Herrera (alvherre[a]dcc.uchile.cl) Y una voz del caos me hablo y me dijo Sonrie y se feliz, podria ser peor. Y sonrei. Y fui feliz. Y fue peor. ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [HACKERS] PostgreSQL on Novell Netware 6.5.
Alvaro Herrera [EMAIL PROTECTED] writes: Some time ago there was a guy from Novell posting on hackers about the porting of PostgreSQL to Netware. He sounded like most of the job was already done, but he wanted to have some patches accepted to be able to build with a toolchain different from GNU make and friends (because it was one or two orders of magnitude faster). He left some time later because of the null support he received for that, it seems. What is this, a troll? We gave that project quite a lot of support. My recollection is that we lost interest somewhere around here: http://archives.postgresql.org/pgsql-patches/2002-08/msg00278.php when it became clear that Netware couldn't or wouldn't try to arrange their code to keep the amount of platform-specific stuff reasonable. The patch as they were proposing it would have been completely unmaintainable --- certainly so for the community, probably for them too. regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] PostgreSQL on Novell Netware 6.5.
Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: Some time ago there was a guy from Novell posting on hackers about the porting of PostgreSQL to Netware. He sounded like most of the job was already done, but he wanted to have some patches accepted to be able to build with a toolchain different from GNU make and friends (because it was one or two orders of magnitude faster). He left some time later because of the null support he received for that, it seems. What is this, a troll? We gave that project quite a lot of support. My recollection is that we lost interest somewhere around here: http://archives.postgresql.org/pgsql-patches/2002-08/msg00278.php when it became clear that Netware couldn't or wouldn't try to arrange their code to keep the amount of platform-specific stuff reasonable. The patch as they were proposing it would have been completely unmaintainable --- certainly so for the community, probably for them too. Last I remember they were going to port gmake to Novell and use that for the port,but we never heard back from them. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: Antw: [HACKERS] PostgreSQL and Novell Netware
I am going to take all of your patches, make one mega-patch, then send it to you for review. --- Ulrich Neumann wrote: Hi Michael, I know all about the story of PostgreSQL for NetWare. I will tell you the story now: First I want to introduce myself: I'm a Novell DeveloperNet SysOp and i'm working with the database team and the C Library team at Novell in Provo/Utah. The story starts last year in may at Novell's BrainShare in Nice/France. I've spoken with several people about the open source community and what's missing on NetWare and how this can be combined with Novells Directory Service to manage all this stuff. During this time only Apache 1.3 and Tomcat 3.2 was available as open source on NetWare. The Database area was a totally vacuum and the need for an alternative for Oracle was huge. The result was that I've started to analyze a lot of databases and after some discussions i've decided to port PostgreSQL because of the features and stability. Nearly at the same time Novell was working on a new C Library to offer a C/C++ environment that is as much POSIX/ANSI C/BSD/UNIX98 compliant as possible. The first step was to enhance this C Library to have all the functionality I need for PostgreSQL. In November i've been in Utah to discuss the open source database PostgreSQL and how it's going. The result was that there is a small team now working on MySQL and PostgreSQL. I'm the man who drives PostgreSQL and another guy, R.Lyon drives MySQL. There are several other people supporting us. Additonal PHP4, mod_perl, JBoss, Motif and several other open source initiatives are in the works at Novell. We are all working together to have a unique solution. Everything is planned to be pushed back to the open source community. I think that's a great benefit for all these projects. In march at Novell's Brainshare in Salt Lake City some of these projects have been demonstrated and nearly everything was functional. Now there is much work in stability, performance and in directory integration together with one unified management tool across all of these open source and the commercial projects. At the end all open source projects will be stress tested in Novell's superlab, the biggest testlab on earth. It's possible to test on hundreds of different servers and thousands of client machines. The first Beta's of PostgreSQL for NetWare have been sent out last week to some selected customers and next week a first beta refresh will be sent out. It is planned to ship all these open source projects during this summer, and the new management tool in the 1st half next year. Apache2 was the first in that line. Ulrich Neumann Michael Meskes [EMAIL PROTECTED] 12.06.2002 16:49:11 Hi, there were several people at my talk asking if PostgreSQL is available on Novell Netware. I know I read about someone working on this, but didn't follow the thread at all since I do not have any Netware servers. Does anyone out there know more? Thanks in advance. Michael -- Michael Meskes [EMAIL PROTECTED] Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL! ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) -- This e-mail is virus scanned Diese e-mail ist virusgeprueft ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[HACKERS] PostgreSQL and Novell Netware
Hi, there were several people at my talk asking if PostgreSQL is available on Novell Netware. I know I read about someone working on this, but didn't follow the thread at all since I do not have any Netware servers. Does anyone out there know more? Thanks in advance. Michael -- Michael Meskes [EMAIL PROTECTED] Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL! ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] PostgreSQL and Novell Netware
Michael Meskes wrote: Hi, there were several people at my talk asking if PostgreSQL is available on Novell Netware. I know I read about someone working on this, but didn't follow the thread at all since I do not have any Netware servers. Attached is an email message from someone who is working on it. This is the first I have heard of a Netware port. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 From [EMAIL PROTECTED] Tue Jun 11 10:20:54 2002 Return-path: [EMAIL PROTECTED] Received: from postgresql.org (postgresql.org [64.49.215.8]) by candle.pha.pa.us (8.11.6/8.10.1) with ESMTP id g5BEKrs26980 for [EMAIL PROTECTED]; Tue, 11 Jun 2002 10:20:53 -0400 (EDT) Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id E71DB476475; Tue, 11 Jun 2002 10:20:47 -0400 (EDT) Received: from postgresql.org (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with SMTP id E021E47641C; Tue, 11 Jun 2002 10:20:29 -0400 (EDT) Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 78C77475905 for [EMAIL PROTECTED]; Tue, 11 Jun 2002 10:20:17 -0400 (EDT) Received: from mail.gne.de (mail.gne.de [213.83.0.2]) by postgresql.org (Postfix) with ESMTP id C02B0475864 for [EMAIL PROTECTED]; Tue, 11 Jun 2002 10:20:15 -0400 (EDT) Received: from DO5GNE-MTA by mail.gne.de with Novell_GroupWise; Tue, 11 Jun 2002 16:19:39 +0200 Message-ID: [EMAIL PROTECTED] X-Mailer: Novell GroupWise Internet Agent 6.0.1 Date: Tue, 11 Jun 2002 16:19:21 +0200 From: Ulrich Neumann [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [HACKERS] Native Win32/OS2/BeOS/NetWare ports MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Guinevere: 1.1.14 ; GNE Grebe Neumann Gl Precedence: bulk Sender: [EMAIL PROTECTED] Status: OR Hello together i've seen a lot of discussion about a native win32/OS2/BEOS port of PostgreSQL. During the last months i've ported PostgreSQL over to Novell NetWare and i've changed the code that I use pthreads instead of fork() now. I had a lot of work with the variables and cleanup but mayor parts are done. I would appreciate if we could combine this work. My plan was to finish this port, discuss the port with other people and offer all the work to the PostgreSQL source tree, but now i'm jumping in here because of all the discussions. What i've done in detail: - i've defined #USE_PTHREADS in pg_config.h to differentiate between the forked and the threaded backend. - I've added several parts in postmaster.c so all functions are based on pthreads now. - I've changed the signal handling because signals are process based - I've changed code in ipc.c to have a clean shutdown of threads - I've written some functions to switch the global variables. The globals are controled with POSIX semaphores. - I've written a new implementation of shared memory and semaphores- With pthreads I don't need real shared memory any more and i'm using POSIX semaphores now - Several minor changes. There is still some more work to do like fixing memory leaks or handling bad situations, but in general it's functional on NetWare. BTW: Is it possible to add some lines on the PostgreSQL webpage that there is a first beta of PostgreSQL for NetWare available and to offer a binary download for the NetWare version? Ulrich Neumann -- This e-mail is virus scanned Diese e-mail ist virusgeprueft ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly