From owner-freebsd-questions@FreeBSD.ORG Tue Nov 9 06:46:01 2004 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id DD21A16A4CE for ; Tue, 9 Nov 2004 06:46:01 +0000 (GMT) Received: from sccimhc92.asp.att.net (sccimhc92.asp.att.net [63.240.76.166]) by mx1.FreeBSD.org (Postfix) with ESMTP id 78ED443D2F for ; Tue, 9 Nov 2004 06:46:01 +0000 (GMT) (envelope-from freebsd@nbritton.org) Received: from nbritton.org (12-223-129-46.client.insightbb.com[12.223.129.46]) by sccimhc92.asp.att.net (sccimhc92) with SMTP id <20041109064600i92002am4ge>; Tue, 9 Nov 2004 06:46:00 +0000 Message-ID: <419067A7.7010704@nbritton.org> Date: Tue, 09 Nov 2004 00:45:59 -0600 From: Nikolas Britton User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 X-Accept-Language: en-us, en MIME-Version: 1.0 To: James Pole References: <419027B8.8050202@nbritton.org> <1851C0CE-3206-11D9-867A-000D93341F5C@pole.net.nz> In-Reply-To: <1851C0CE-3206-11D9-867A-000D93341F5C@pole.net.nz> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit cc: freebsd-questions@freebsd.org Subject: Re: FreeBSD + MySQL or PostgreSQL X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 09 Nov 2004 06:46:02 -0000 James Pole wrote: > On 9/11/2004, at 3:13 PM, Nikolas Britton wrote: > >> Which one, MySQL or PostgreSQL, is most compatible, stable, etc. >> with FreeBSD 4.x and 5.x >> >> P.S. I'm NOT looking for opinions on which is better a product. > > > Both work perfectly fine with FreeBSD, although I find MySQL easier to > set up and maintain under FreeBSD. There are also more documentation > available on the web for MySQL+FreeBSD. However it is possible to run > PostgreSQL on FreeBSD without any problems at all, especially if you > have experience using PostgreSQL on other platforms (eg Linux) as the > set-up and maintenance process should be similar on both sides of the > fence. > > Are there any specific requirements you need in an SQL database server? > Yes, whatever works best on FreeBSD! :-) I seem to remember that MySQL had issues with FreeBSD something about pthreads or whatnot. I also seem to remember hearing that Postgre is built and maintained on *BSD systems, This would lead me to belive that Postgre is the better choice for a "production" FreeBSD server? Currently I'm using MySQL on a production FreeBSD 5.2.1 box. It had some problems at first with table locking and corruption but it's seems to be running fine now, I'm scared to work on it for fear of MySQL freaking out though. the only thing I run on it is kronolith/horde (groupware) and a wiki so it's never seen a heavy load. also it uses up alot of pids,