From owner-freebsd-questions@FreeBSD.ORG  Sat Nov 26 00:50:52 2005
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 3DC1116A41F
	for <freebsd-questions@freebsd.org>;
	Sat, 26 Nov 2005 00:50:52 +0000 (GMT)
	(envelope-from lists@stringsutils.com)
Received: from zoraida.natserv.net (p65-147.acedsl.com [66.114.65.147])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 4271D43D5E
	for <freebsd-questions@freebsd.org>;
	Sat, 26 Nov 2005 00:50:51 +0000 (GMT)
	(envelope-from lists@stringsutils.com)
Received: from 35st-server.simplicato.com
	(static-71-249-233-130.nycmny.east.verizon.net [71.249.233.130])
	by zoraida.natserv.net (Postfix) with ESMTP id 86B887E0A;
	Fri, 25 Nov 2005 19:50:50 -0500 (EST)
References: <810a540e0511102242p22423149i3e5bb92f6b602145@mail.gmail.com>
Message-ID: <cone.1132966342.868117.5442.5001@35st-server.simplicato.com>
X-Mailer: http://www.courier-mta.org/cone/
From: Francisco Reyes <lists@stringsutils.com>
To: Pat Maddox <pergesu@gmail.com>
Date: Fri, 25 Nov 2005 19:52:22 -0500
Mime-Version: 1.0
Content-Type: text/plain; format=flowed; charset="US-ASCII"
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
Cc: FreeBSD Questions <freebsd-questions@freebsd.org>
Subject: Re: Upgrading to pgsql 8.1 via ports
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
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: Sat, 26 Nov 2005 00:50:52 -0000

Pat Maddox writes:


>  Should I use postgresql81-server now instead? 

Yes.

> What do I need
> to do in order to upgrade my system to use pgsql 8.1?

I believe you  need to go a pg_dumpall all to copy data. Also keep a copy of 
your postgresql.conf and pg_hba.conf

If you don't have any dependencies on the postgresql ports you can 
pg_dumpall, delete porst, install new ones. If you have dependencies you 
need to use portupgrade or something like it.

As another poster suggested if using portupgrade you will need to use the 
"-o" flag.