Re: Migrating 7.1.3 to 7.3.4 problem

Hi,

I should think there will be no other way but to follow this procedure:

Backup your /var/lib/pgsql directory
Reinstall 7.1.3 (either rpm oder install from source)
Copy your backed up /var/lib/pgsql_bak directory into the new
/var/lib/pgsql directory created during installation
Fire up the postmaster
Dump everything
Shutdown postmaster
Move /var/lib/psql and /opt/pgsql (or whereever your PostgreSQL-binaries
reside) out of the way
Install 7.3.4 (why not 7.4.1?) from source or rpm
Fire up the postmaster
Restore your dumps.

I don't think there's a way to directly import your old 7.1.x
database-directory into a more recent major release PostgreSQL
installation.

Kind regards

    Markus

> -----Ursprüngliche Nachricht-----
> Von: JM [mailto:jerome@gmanmi.tv]
> Gesendet: Donnerstag, 12. Februar 2004 10:09
> An: pgsql-general@postgresql.org
> Betreff: [GENERAL] Migrating 7.1.3 to 7.3.4 problem
>
>
> Hi,
>
> Just recently one of my box went down due to filestsystem
> corruption.. Luckily
> I was able to recover my /var/lib/pgsql directory... now my
> problem lies on
> how to recover this data...
>
> all my boxes runs on rh9 and compiling the source and
> rebuilding the source
> rpm is not helping out either..
>
> is there a way on how to migrate my old data?
>
>
> TIA
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index
> scan if your
>       joining column's datatypes do not match
>