Thread: Which OS to Use for Postgresql
Which operating system should I use for a Postgresql server? Linux? Which version? Other? I do database work for several medium size companies. They have about 100 users per company. One has 3 different locations. All woul dlike to put some data on the internet, both publish and input from the internet. Is there anywhere that discusses configurations for postgresql? Thanks, Al
On Wed, 16 May 2001, Al Frick wrote: > Which operating system should I use for a Postgresql server? > > Linux? Which version? > > Other? > > I do database work for several medium size companies. They have about > 100 users per company. One has 3 different locations. All woul dlike > to put some data on the internet, both publish and input from the > internet. > > Is there anywhere that discusses configurations for postgresql? > Postgresql is pretty platform independent so there is no clear answer. Many people favor various linux distributions others like freebsd. The bottom line is postgresql runs fine with most *nix platforms so you should choose one that you are already familiar with, and which is best for your other needs. ps. Let's not start another pointless discussion about this on the list. If you look in the archive you can find many messages on this topic. - Einar Karttunen
Al Frick <bscinc2000@yahoo.comNOSPAM> wrote: > Which operating system should I use for a Postgresql server? One that the person(s) who will have to administrate it are familiar with and that is stable. > Linux? Which version? Database servers usually have high stability requirements. For Linux, consider a distribution that emphasises stability, upgradability and remote maintenance. > Is there anywhere that discusses configurations for postgresql? The -admin list is probably the best place. HTH, Ray -- The road to hell is paved with telecom billing requirements.
On Wed, 16 May 2001, Al Frick wrote: > Which operating system should I use for a Postgresql server? > You should probably use something you know well, at least at first. > Linux? Which version? > Debian is a reasonable choice if you're going to go the linux route, so is redhat, use slackware only if you want to learn rather a lot about linux internals, the *bsd operating systems are also strong and reliable. > I do database work for several medium size companies. They have about > 100 users per company. One has 3 different locations. All woul dlike > to put some data on the internet, both publish and input from the > internet. > > Is there anywhere that discusses configurations for postgresql? > http://www.techdocs.postgresql.org good luck
Hi all, That link should be : http://techdocs.postgresql.org (no www. on the start of it). If the site looks a bit messy at the moment, it's coz I'm working on it directly.... :-) + Justin larry a price wrote: > > On Wed, 16 May 2001, Al Frick wrote: > > > Which operating system should I use for a Postgresql server? > > > > You should probably use something you know well, at least at first. > > > Linux? Which version? > > > Debian is a reasonable choice if you're going to go the linux route, so is > redhat, use slackware only if you want to learn rather a lot about linux > internals, the *bsd operating systems are also strong and reliable. > > > I do database work for several medium size companies. They have about > > 100 users per company. One has 3 different locations. All woul dlike > > to put some data on the internet, both publish and input from the > > internet. > > > > Is there anywhere that discusses configurations for postgresql? > > > http://www.techdocs.postgresql.org > > good luck > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl -- "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
The OS matters some. But Linux/BSD/Solaris are all a lot a like. What matters more is what hardware you pick and how much RAM you have. Things like ECC RAM, redundant power supplies and RAID contribute more to stbility. > -----Original Message----- > From: bscinc2000@yahoo.comNOSPAM [mailto:bscinc2000@yahoo.comNOSPAM] > Sent: Tuesday, May 15, 2001 7:06 PM > To: pgsql-general@postgresql.org > Subject: [GENERAL] Which OS to Use for Postgresql > > > Which operating system should I use for a Postgresql server? > > Linux? Which version? > > Other? > > I do database work for several medium size companies. They have about > 100 users per company. One has 3 different locations. All woul dlike > to put some data on the internet, both publish and input from the > internet. >> This email message is for the sole use of the intended recipient(s) and may contain proprietary and confidential information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Thank you
On Wed, May 16, 2001 at 02:05:36AM +0000, some SMTP stream spewed forth: > Which operating system should I use for a Postgresql server? Despite the fact that it really doesn't matter, I highly recommend FreeBSD. We have had nothing but exceptional performance out of it. (I recommend you use FreeBSD rather than Linux, but PostgreSQL is quite happy with whatever ole mess you throw it into.) *snippity snip snip* > Is there anywhere that discusses configurations for postgresql? Er, the mailing lists. ;-) > Thanks, > > Al dan