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?

Thanks

Sameer





__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

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

More information on upgrading PostgreSQL can be found in the manual:

For you that would be:
http://www.postgresql.org/docs/7.4/i...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
>
>


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

hi!

i once had a similair problem, but due to a partial hard drive failure.
all i needed was the data directory from the 7.2 version. i then
installed pgsql7.2 into a different directory and ran the 7.2 server
with the -D parameter pointing to the old data directory. next, i ran
pg_dump and pg_dump_all to dump all my user/database info which i then
imported into pgsql7.4. i have to say i encountered no errors in the
process so it went through rather smoothly. you can also run both
versions at the same time, you just need to change the port from 5432 to
something else, ie 5433 for one version.

so as long as you have your data directory intact, you should imo have
no big problems getting your data from one to another version. there may
be other solutions but this one worked for me

good luck,
M

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?

---------------------------(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