Thread: postgresql error
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!! thanks bruce
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