From owner-freebsd-questions@FreeBSD.ORG Mon Apr 24 17:49:34 2006 Return-Path: X-Original-To: freebsd-questions@freebsd.org 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 E770716A401 for ; Mon, 24 Apr 2006 17:49:34 +0000 (UTC) (envelope-from scrappy@hub.org) Received: from hub.org (hub.org [200.46.204.220]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6068843D45 for ; Mon, 24 Apr 2006 17:49:32 +0000 (GMT) (envelope-from scrappy@hub.org) Received: from localhost (unknown [200.46.208.251]) by hub.org (Postfix) with ESMTP id C0C6662C8FB; Mon, 24 Apr 2006 14:49:30 -0300 (ADT) Received: from hub.org ([200.46.204.220]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 46576-01-2; Mon, 24 Apr 2006 14:49:16 -0300 (ADT) Received: from ganymede.hub.org (blk-222-82-85.eastlink.ca [24.222.82.85]) by hub.org (Postfix) with ESMTP id 0C4B262CCF8; Mon, 24 Apr 2006 14:36:29 -0300 (ADT) Received: by ganymede.hub.org (Postfix, from userid 1000) id 5BA0F482CB; Mon, 24 Apr 2006 14:17:38 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 573AC47D68; Mon, 24 Apr 2006 14:17:38 -0300 (ADT) Date: Mon, 24 Apr 2006 14:17:38 -0300 (ADT) From: "Marc G. Fournier" To: polinsky@acm.org In-Reply-To: <444cd053b2c430.26135968@nyct.net> Message-ID: <20060424141701.Y34052@ganymede.hub.org> References: <444cd053b2c430.26135968@nyct.net> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed Cc: freebsd-questions@FreeBSD.org Subject: Re: Freebsd6.0 and postgresql X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 24 Apr 2006 17:49:35 -0000 On Mon, 24 Apr 2006, polinsky@acm.org wrote: > I have an important database comprised of about 380 tables and several > gigs of space currently running on Posgresql 7.4. and Freebsd 6.0. I > have been contemplating moving the database to the 8 series, possibly > postgresql 8.1. I would have no problem in dumping the data, recreating > the tables under 8.1, if requried, and then re-loading the data. I have > been concerned about the seeming lack of interfaces to the 8 series. I > have the perly, pythopn, ruby and odbc sources installed for postgresql > 7.4. I have not seen similar dirvers for the 8 series in the ports > system. Can I continue to use the same drivers with the new database or > will I experience some other problems? Yes ... all of our servers, 4.x and 6.x, are using postgresql81-client, and each of the interfaces you list above are installed over various machines, without any problems ... ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664