Postgres Pro
Downloads
Home   >   mailing lists

Thread: newbie question

newbie question

From
Sameer Sharma
Date:
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

Re: newbie question

From
Andreas Pflug
Date:
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

Re: newbie question

From
"A.j. Langereis"
Date:
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
> 
>

Re: newbie question

From
Miha Radej
Date:
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?