I have used Postgresql v.7.3 under Fedora v.1.0
working fine all the time but after I have made
upgrade to Fedora 4, when I try init my postgresql
using the command line :
service postgresql start
I couldn't start my database, an error message appears
as follow :

> Was an old version of the format of the data base.
It needs to update the data format before using
PostgreSQL. To
see/usr/share/doc/postgresql-8.0.3/README.rpm-dist for
more information.

Please I hope for help to me . Thanks


__________________________________________________
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
Regístrate ya - http://correo.espanol.yahoo.com/

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Hi,

On Fri, 16 Dec 2005, Miguel wrote:

> I have used Postgresql v.7.3 under Fedora v.1.0
> working fine all the time but after I have made
> upgrade to Fedora 4, when I try init my postgresql
> using the command line :
> service postgresql start
> I couldn't start my database, an error message appears
> as follow :
>
>> Was an old version of the format of the data base.
> It needs to update the data format before using
> PostgreSQL. To
> see/usr/share/doc/postgresql-8.0.3/README.rpm-dist for
> more information.

It seems that you've run rpm -U during upgrade For major versions (and
for some minor versions) you need to re-initdb the data cluster.

Now you have to install the old version again and take a dump before
upgrade. Follow this document for a major version RPM upgrade:

http://pgfoundry.org/docman/view.php...ation-PGDG.pdf

It is safe to remove the existing RPMs since they don't remove database
cluster (but backup is everything :-) )Then install the old version again.

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

--- Miguel <migabolinux@yahoo.com> wrote:

> I have used Postgresql v.7.3 under Fedora v.1.0
> working fine all the time but after I have made
> upgrade to Fedora 4, when I try init my
> postgresql
> using the command line :
> service postgresql start
> I couldn't start my database, an error message
> appears
> as follow :
>
> > Was an old version of the format of the data base.
>
> It needs to update the data format before using
> PostgreSQL. To
> see/usr/share/doc/postgresql-8.0.3/README.rpm-dist
> for
> more information.
>
> Please I hope for help to me . Thanks

Miguel, it sounds like pgsql was updated between FC1
and FC4.

as i understand it, the proper way to do this is to
dump the db under 7.3 and then restore it to 8.0.3.

based on the error message, it doesn't seem you can
just update the db without updating the data format
via dump/retore.

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly