Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 25 Nov 2005 19:52:22 -0500
From:      Francisco Reyes <lists@stringsutils.com>
To:        Pat Maddox <pergesu@gmail.com>
Cc:        FreeBSD Questions <freebsd-questions@freebsd.org>
Subject:   Re: Upgrading to pgsql 8.1 via ports
Message-ID:  <cone.1132966342.868117.5442.5001@35st-server.simplicato.com>
References:  <810a540e0511102242p22423149i3e5bb92f6b602145@mail.gmail.com>

next in thread | previous in thread | raw e-mail | index | archive | help
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. 



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?cone.1132966342.868117.5442.5001>