postgresql error

On Sat, 12 Mar 2005 10:13:34 -0800, bruce <bedouglas@earthlink.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@gmail.com
LlamaLand http://netllama.linux-sxs.org

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@gmail.com]
Sent: Saturday, March 12, 2005 3:30 PM
To: bedouglas@earthlink.net
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] postgresql error

On Sat, 12 Mar 2005 10:13:34 -0800, bruce <bedouglas@earthlink.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@gmail.com
LlamaLand http://netllama.linux-sxs.org

Shutdown postgresql, delete everything under /var/lib/pgsql/ and then
start postgresql again.

On Sat, 12 Mar 2005 16:51:55 -0800, bruce <bedouglas@earthlink.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@gmail.com]
Sent: Saturday, March 12, 2005 3:30 PM
To: bedouglas@earthlink.net
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] postgresql error

On Sat, 12 Mar 2005 10:13:34 -0800, bruce <bedouglas@earthlink.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@gmail.com
LlamaLand http://netllama.linux-sxs.org