linux/bsd

Started by Richard Boyesabout 25 years ago8 messagesgeneral
Jump to latest
#1Richard Boyes
r.boyes@auckland.ac.nz

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.

#2Brett W. McCoy
bmccoy@chapelperilous.net
In reply to: Richard Boyes (#1)
Re: linux/bsd

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.

#3Justin Clift
justin@postgresql.org
In reply to: Richard Boyes (#1)
Re: linux/bsd

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

#4The Hermit Hacker
scrappy@hub.org
In reply to: Justin Clift (#3)
Re: 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

#5Willis, Ian (Ento, Canberra)
Ian.Willis@ento.csiro.au
In reply to: The Hermit Hacker (#4)
RE: linux/bsd

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

#6Chris Jones
chris@mt.sri.com
In reply to: Richard Boyes (#1)
Re: linux/bsd

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

#7Peter Eisentraut
peter_e@gmx.net
In reply to: Richard Boyes (#1)
Re: linux/bsd

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/

#8Justin Clift
justin@postgresql.org
In reply to: The Hermit Hacker (#4)
Re: linux/bsd

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