From owner-freebsd-questions@FreeBSD.ORG Tue Nov 9 06:00:04 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 7FCE516A4CE for ; Tue, 9 Nov 2004 06:00:04 +0000 (GMT) Received: from wolf.bytecraft.au.com (wolf.bytecraft.au.com [203.39.118.1]) by mx1.FreeBSD.org (Postfix) with ESMTP id CDB7943D58 for ; Tue, 9 Nov 2004 06:00:02 +0000 (GMT) (envelope-from murraytaylor@bytecraftsystems.com) Received: from localhost (localhost [127.0.0.1])iA9601EI029350; Tue, 9 Nov 2004 17:00:01 +1100 (EST) (envelope-from murraytaylor@bytecraftsystems.com) Received: from wolf.bytecraft.au.com ([127.0.0.1]) by localhost (wolf.bytecraft.au.com [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 29145-02; Tue, 9 Nov 2004 17:00:00 +1100 (EST) Received: from svmarshal.bytecraft.au.com ([10.0.0.4])iA95w1UB029302; Tue, 9 Nov 2004 16:58:01 +1100 (EST) (envelope-from murraytaylor@bytecraftsystems.com) Received: from wombat.bytecraft.au.com (Not Verified[10.0.0.3]) by svmarshal.bytecraft.au.com with MailMarshal (v5,0,3,78) id ; Tue, 09 Nov 2004 16:58:01 +1100 Received: from [10.0.17.42] (wstaylorm.dand06.au.bytecraft.au.com [10.0.17.42]) by wombat.bytecraft.au.com (Postfix) with ESMTP id B2BFD3F0F; Tue, 9 Nov 2004 16:57:55 +1100 (EST) From: Murray Taylor To: James Pole In-Reply-To: <1851C0CE-3206-11D9-867A-000D93341F5C@pole.net.nz> References: <419027B8.8050202@nbritton.org> <1851C0CE-3206-11D9-867A-000D93341F5C@pole.net.nz> Content-Type: text/plain Organization: Bytecraft Systems Message-Id: <1099979874.64462.97.camel@wstaylorm.dand06.au.bytecraft.au.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Tue, 09 Nov 2004 16:57:55 +1100 Content-Transfer-Encoding: 7bit cc: Nikolas Britton cc: freebsdquestions 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:00:04 -0000 On Tue, 2004-11-09 at 15:16, 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? > > Regards, > James > We currently run MySQL in production very satisfactorily, and both on development systems. >From a technical standpoint only (ACID compliance) we are considering switching the production stuff to PostgreSQL cheers mjt -- Murray Taylor Special Projects Engineer --------------------------------- Bytecraft Systems & Entertainment --------------------------------------------------------------- The information transmitted in this e-mail is for the exclusive use of the intended addressee and may contain confidential and/or privileged material. Any review, re-transmission, dissemination or other use of it, or the taking of any action in reliance upon this information by persons and/or entities other than the intended recipient is prohibited. If you received this in error, please inform the sender and/or addressee immediately and delete the material. E-mails may not be secure, may contain computer viruses and may be corrupted in transmission. Please carefully check this e-mail (and any attachment) accordingly. No warranties are given and no liability is accepted for any loss or damage caused by such matters. --------------------------------------------------------------- **************************************************************** This Email has been scanned for Viruses by MailMarshal. ****************************************************************