Thread: linux/bsd
Hello all, I'm in the process of making some decisions as to what OS I should be using for a product that development will begin on soon. It's a web based thing using postgres, apache etc and will be all on one machine. My question is to what operating system would be a better one to use for postgres. ie linux/bsd. I know postgres works fine on both but some opinion from the postgres developer community as to which OS they prefer would have a bearing on this decision. PS sorry in advance for posting a question that might spark a lot of opinions. Thanks Richard.
On Mon, 9 Apr 2001, Richard Boyes wrote:
> I'm in the process of making some decisions as to
> what OS I should be using for a product that development
> will begin on soon. It's a web based thing using postgres,
> apache etc and will be all on one machine.
>
> My question is to what operating system would be a better
> one to use for postgres. ie linux/bsd.
>
> I know postgres works fine on both but some opinion
> from the postgres developer community as to which OS
> they prefer would have a bearing on this decision.
I've only used it on Linux, so I can only vouch for that. BSD has a
better reputation for stability and robustness, so for the ultimate
server, BSD may be your best choice (this isn't to say Linux is stable and
robust, because it is). You will find better hardware support for Linux,
because there is more stuff that will run under Linux than will run under
FreeBSD.
This is probably not at ahll helpful! I'd say just pick one and go with
it.
-- Brett
http://www.chapelperilous.net/btfwk/
------------------------------------------------------------------------
A rolling stone gathers momentum.
Hi Richard, Solaris 8 INTEL is very stable and free for commercial use : http://www.sun.com/solaris/ You can download it directly from the web too (full version, no timeouts or anything holding back): http://www.sun.com/software/solaris/binaries/download.html It's kind of picky about which hardware it will work on though. There is a list at : http://soldc.sun.com/support/drivers/hcl/8/101/BOOK.htm If you have hardware it likes, I'd go with Solaris INTEL, otherwise one of the BSD crowd (known for stability) or Linux. Regards and best wishes, Justin Clift Richard Boyes wrote: > > Hello all, > > I'm in the process of making some decisions as to > what OS I should be using for a product that development > will begin on soon. It's a web based thing using postgres, > apache etc and will be all on one machine. > > My question is to what operating system would be a better > one to use for postgres. ie linux/bsd. > > I know postgres works fine on both but some opinion > from the postgres developer community as to which OS > they prefer would have a bearing on this decision. > > PS sorry in advance for posting a question that might > spark a lot of opinions. > > Thanks > Richard. > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi
On Mon, 9 Apr 2001, Justin Clift wrote: > Hi Richard, > > Solaris 8 INTEL is very stable and free for commercial use : > http://www.sun.com/solaris/ > > You can download it directly from the web too (full version, no timeouts > or anything holding back): > http://www.sun.com/software/solaris/binaries/download.html > > It's kind of picky about which hardware it will work on though. There > is a list at : > http://soldc.sun.com/support/drivers/hcl/8/101/BOOK.htm > > If you have hardware it likes, I'd go with Solaris INTEL, otherwise one > of the BSD crowd (known for stability) or Linux. Based on my personal experiences (University I work at is predominantly Solaris based for Unix .. .slowly shifting *muhahaha*) ... Solaris INTEL is one of the worst OSs I've had the misfortune to deal with :( Ppl complain about how the BSD OSs don't support as much hardware as Linux, but Solaris takes the cake in that department ... you have to go to Adaptec's web site to get drives if you want to use a U160 SCSI controller, as *it* isn't supported :( > > Regards and best wishes, > > Justin Clift > > Richard Boyes wrote: > > > > Hello all, > > > > I'm in the process of making some decisions as to > > what OS I should be using for a product that development > > will begin on soon. It's a web based thing using postgres, > > apache etc and will be all on one machine. > > > > My question is to what operating system would be a better > > one to use for postgres. ie linux/bsd. > > > > I know postgres works fine on both but some opinion > > from the postgres developer community as to which OS > > they prefer would have a bearing on this decision. > > > > PS sorry in advance for posting a question that might > > spark a lot of opinions. > > > > Thanks > > Richard. > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 2: you can get off all lists at once with the unregister command > > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > -- > "My grandfather once told me that there are two kinds of people: those > who work and those who take the credit. He told me to try to be in the > first group; there was less competition there." > - Indira Gandhi > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
I personally think that solaris/sparc is OK but pricey, solaris/intel sucks. I currently administer a number of sparc/solaris boxes and in the next 18 months will be migrating all bar one of these boxes to linux. We evaluated solaris/intel however the number of hoops that one has to just through make the concept of commodisation fly out the window. -- Ian Willis -----Original Message----- From: The Hermit Hacker [mailto:scrappy@hub.org] Sent: Monday, 9 April 2001 12:52 PM To: Justin Clift Cc: Richard Boyes; pgsql-general@postgresql.org Subject: Re: [GENERAL] linux/bsd On Mon, 9 Apr 2001, Justin Clift wrote: > Hi Richard, > > Solaris 8 INTEL is very stable and free for commercial use : > http://www.sun.com/solaris/ > > You can download it directly from the web too (full version, no timeouts > or anything holding back): > http://www.sun.com/software/solaris/binaries/download.html > > It's kind of picky about which hardware it will work on though. There > is a list at : > http://soldc.sun.com/support/drivers/hcl/8/101/BOOK.htm > > If you have hardware it likes, I'd go with Solaris INTEL, otherwise one > of the BSD crowd (known for stability) or Linux. Based on my personal experiences (University I work at is predominantly Solaris based for Unix .. .slowly shifting *muhahaha*) ... Solaris INTEL is one of the worst OSs I've had the misfortune to deal with :( Ppl complain about how the BSD OSs don't support as much hardware as Linux, but Solaris takes the cake in that department ... you have to go to Adaptec's web site to get drives if you want to use a U160 SCSI controller, as *it* isn't supported :( > > Regards and best wishes, > > Justin Clift > > Richard Boyes wrote: > > > > Hello all, > > > > I'm in the process of making some decisions as to > > what OS I should be using for a product that development > > will begin on soon. It's a web based thing using postgres, > > apache etc and will be all on one machine. > > > > My question is to what operating system would be a better > > one to use for postgres. ie linux/bsd. > > > > I know postgres works fine on both but some opinion > > from the postgres developer community as to which OS > > they prefer would have a bearing on this decision. > > > > PS sorry in advance for posting a question that might > > spark a lot of opinions. > > > > Thanks > > Richard. > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 2: you can get off all lists at once with the unregister command > > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > -- > "My grandfather once told me that there are two kinds of people: those > who work and those who take the credit. He told me to try to be in the > first group; there was less competition there." > - Indira Gandhi > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
On Mon, Apr 09, 2001 at 11:00:04AM +1200, Richard Boyes wrote:
> My question is to what operating system would be a better
> one to use for postgres. ie linux/bsd.
As far as PG is concerned, it doesn't really matter; PG will run very
nicely on any unix. In my experience, Sun's machines have better I/O
than anybody's PCs, but you pay a price for that. Also, PG will
probably run just fine on a cheap commodity PC -- an expensive PC
should do even better.
You should probably choose your OS based on the OS itself, not on PG.
Basically, what are you going to be able to manage most effectively?
For me, the clear choice is NetBSD. For others, the choice is
different. But the reliability of your database is going to depend on
the reliability of your OS, which is going to depend (partially) on
how familiar and comfortable you are with it.
Chris
--
chris@mt.sri.com -----------------------------------------------------
Chris Jones SRI International, Inc.
www.sri.com
Attachment
Richard Boyes writes: > My question is to what operating system would be a better > one to use for postgres. ie linux/bsd. More important things to worry about are a fast disk, a modern file system, lots of memory, lots of CPU. The operating system ends up being a matter of taste mostly. -- Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
Hi Marc, No argument there. Solaris 8 is a LOT better then previous versions in regards to driver support, but still a long way behind *BSD, linux, Windows, etc. BUT, if you've got hardware it DOES work on... it's really nice. Regards and best wishes, Justin Clift The Hermit Hacker wrote: > > On Mon, 9 Apr 2001, Justin Clift wrote: > > > Hi Richard, > > > > Solaris 8 INTEL is very stable and free for commercial use : > > http://www.sun.com/solaris/ > > > > You can download it directly from the web too (full version, no timeouts > > or anything holding back): > > http://www.sun.com/software/solaris/binaries/download.html > > > > It's kind of picky about which hardware it will work on though. There > > is a list at : > > http://soldc.sun.com/support/drivers/hcl/8/101/BOOK.htm > > > > If you have hardware it likes, I'd go with Solaris INTEL, otherwise one > > of the BSD crowd (known for stability) or Linux. > > Based on my personal experiences (University I work at is predominantly > Solaris based for Unix .. .slowly shifting *muhahaha*) ... Solaris INTEL > is one of the worst OSs I've had the misfortune to deal with :( Ppl > complain about how the BSD OSs don't support as much hardware as Linux, > but Solaris takes the cake in that department ... you have to go to > Adaptec's web site to get drives if you want to use a U160 SCSI > controller, as *it* isn't supported :( > > > > > Regards and best wishes, > > > > Justin Clift > > > > Richard Boyes wrote: > > > > > > Hello all, > > > > > > I'm in the process of making some decisions as to > > > what OS I should be using for a product that development > > > will begin on soon. It's a web based thing using postgres, > > > apache etc and will be all on one machine. > > > > > > My question is to what operating system would be a better > > > one to use for postgres. ie linux/bsd. > > > > > > I know postgres works fine on both but some opinion > > > from the postgres developer community as to which OS > > > they prefer would have a bearing on this decision. > > > > > > PS sorry in advance for posting a question that might > > > spark a lot of opinions. > > > > > > Thanks > > > Richard. > > > > > > ---------------------------(end of broadcast)--------------------------- > > > TIP 2: you can get off all lists at once with the unregister command > > > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > > > -- > > "My grandfather once told me that there are two kinds of people: those > > who work and those who take the credit. He told me to try to be in the > > first group; there was less competition there." > > - Indira Gandhi > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 2: you can get off all lists at once with the unregister command > > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > > > Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy > Systems Administrator @ hub.org > primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi