From owner-freebsd-questions@FreeBSD.ORG  Mon Apr 24 13:24:28 2006
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 729C316A400
	for <freebsd-questions@FreeBSD.org>;
	Mon, 24 Apr 2006 13:24:28 +0000 (UTC)
	(envelope-from polinsky@acm.org)
Received: from bsd4.nyct.net (mail-out4.nyct.net [216.139.141.4])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 8CBAC43D60
	for <freebsd-questions@FreeBSD.org>;
	Mon, 24 Apr 2006 13:24:26 +0000 (GMT)
	(envelope-from polinsky@acm.org)
Received: from webmail.nyct.net (bsd6.nyct.net [216.139.147.15])
	by bsd4.nyct.net (8.13.4/8.13.1) with SMTP id k3ODONdp044801;
	Mon, 24 Apr 2006 09:24:23 -0400 (EDT)
	(envelope-from polinsky@acm.org)
From: polinsky@acm.org
To: freebsd-questions@FreeBSD.org
Date: Mon, 24 Apr 2006 09:19:15 -400
Message-Id: <444cd053b2c430.26135968@nyct.net>
X-Authenticated-IP: [167.153.17.65]
X-Sender: polinsky@mail.nyct.net
X-Mailer: PHPost 1.07 (http://webgadgets.com/phpost/)
MIME-version: 1.0
Content-type: text/plain; charset="iso-8859-1"
Cc: 
Subject: Freebsd6.0 and postgresql
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
Reply-To: polinsky@acm.org
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 24 Apr 2006 13:24:28 -0000

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?

thank yo very much

Alan Polinsky