Re: Upgrading database format on PostgreSQL 8.1 on FC6

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Upgrading database format on PostgreSQL 8.1 on FC6
Date: 2008-08-01 22:20:30
Message-ID: 48938C2E.3000700@sympatico.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Arjun Datta wrote:
> But on the newer machine (I cannot verify if postgres has ever been run
> on it or if it did when last), even before I try to restore, I notice
> that on startup I get the following error.
>
> [root(at)devdb3 8.1]# service postgresql start
>
> An old version of the database format was found.
> You need to upgrade the data format before using PostgreSQL.
> See /usr/share/doc/postgresql-8.1.10/README.rpm-dist for more information.

If there is nothing in current pg databases you want to keep; then have
a look at initdb command; which will initialise your system for current
release installed on system. Any existing data is wiped out.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Frank Bax 2008-08-01 22:34:15 OIDS question
Previous Message Tom Lane 2008-08-01 22:16:59 Re: Upgrading database format on PostgreSQL 8.1 on FC6