Re: postgresql error

From: Lonni J Friedman <netllama(at)gmail(dot)com>
To: bedouglas(at)earthlink(dot)net
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: postgresql error
Date: 2005-03-12 23:29:45
Message-ID: 7c1574a9050312152969386a8c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, 12 Mar 2005 10:13:34 -0800, bruce <bedouglas(at)earthlink(dot)net> wrote:
> hi...
>
> i get a postgres error when i've gone from RH8 to FC3 and am now using
> postgreSQL-7.4.7.
>
> an err msg 'an old version of database format was found. you need to upgrade
> the data format....."
>
> searching google shows that others have seen this, but i can't find a way to
> correct it. i've checked the postrgres site/faq and couldn't find anything
> either. can someone point me to a site/steps that show what i have to do.
> i'm not a postgre user/guru by any means!!

You need to dump the DB from the old version of postgresql and import
it back into the new version. see the pg_dump and pg_restore man
pages.

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama(at)gmail(dot)com
LlamaLand http://netllama.linux-sxs.org

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message bruce 2005-03-13 00:51:55 Re: postgresql error
Previous Message Martijn van Oosterhout 2005-03-12 23:18:39 Re: partitionning