More information on upgrading PostgreSQL can be found in the manual:
For you that would be:
http://www.postgresql.org/docs/7.4/interactive/install-upgrading.html
Your sincerely,
Aarjan Langereis
----- Original Message -----
From: "Andreas Pflug" <pgadmin@pse-consulting.de>
To: "Sameer Sharma" <sash_us2000@yahoo.com>
Cc: <pgadmin-support@postgresql.org>
Sent: Wednesday, November 16, 2005 11:23 PM
Subject: Re: [pgadmin-support] newbie question
> Sameer Sharma wrote:
>
> >Recently, I upgraded my OS from RH8 to Fedora.
> >This implicitly upgraded my database to PG7.4.6
> >from PG7.2.X.
> >Due to this I am unable to use the existing database,
> >since starting postmaster with the same Data gives an
> >initializing data dictionary error (Incompatible
> >between versions).
> >What options do I have in order to save my data?
> >
> >
>
> Wrong list.
> You probably have to downgrade to 7.2 to get your data back.
>
> Regards,
> Andreas
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
>
