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-13 02:19:51 |
Message-ID: | 7c1574a9050312181924d8c0a9@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Shutdown postgresql, delete everything under /var/lib/pgsql/ and then
start postgresql again.
On Sat, 12 Mar 2005 16:51:55 -0800, bruce <bedouglas(at)earthlink(dot)net> wrote:
> so.. what can i just delete and keep going forward. the old version was
> never really used, and we don't have an old version of the postgres app..
>
> thanks
>
> bruce
>
>
> -----Original Message-----
> From: Lonni J Friedman [mailto:netllama(at)gmail(dot)com]
> Sent: Saturday, March 12, 2005 3:30 PM
> To: bedouglas(at)earthlink(dot)net
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] postgresql error
>
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2005-03-13 03:59:58 | Re: Using sequence name depending on other column |
Previous Message | Miroslav Šulc | 2005-03-13 01:34:15 | General query optimization howto |