Problem upgrading postgresql

[Dennis Veatch]

On Wednesday 16 April 2008 21:05:45 Javier Adrián Ortiz de la Tabla wrote:
> El Wed, 16 Apr 2008 18:36:34 -0600
>
> "Richard Pyne" <rpyne at kinfolk.org> escribió:
> > I currently have postgresql version 8.3.0 installed and when I run a
> > lunar update I get the message "A pre 8.3 version of the database was
> > found. You need to upgrade the data format to 8.3. Refer to the
> > INSTALL file located in the tarball for the upgrade procedure. The
> > install will not continue."
> >
> > --Richard
>
> You need to pgdump your database cluster first before upgrading to a
> major postgresql release, after that stop the postgresql server,
> then rename (or delete, but this is not so good idea) the old
> installation directory, and finally
> lin postgresql.
> Here is a more detailed explanation:
> http://www.postgresql.org/docs/8.3/interactive/install-upgrading.html
>
> Please, someone correct me if i'm wrong.

The only manual intervention needed with this module is the dumping of your 
database and then deletion of the file I already mentioned. The lin process 
will take care of the rest. This of course only applies with moving across a 
major release.

-- 
You can tuna piano but you can't tune a fish.

http://www.lunar-linux.org/
It's worth a spin.