From: | "Markus Wollny" <Markus(dot)Wollny(at)computec(dot)de> |
---|---|
To: | <jerome(at)gmanmi(dot)tv>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Migrating 7.1.3 to 7.3.4 problem |
Date: | 2004-02-12 11:07:08 |
Message-ID: | 2266D0630E43BB4290742247C891057502B9D478@dozer.computec.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)gmanmi(dot)tv]
> Gesendet: Donnerstag, 12. Februar 2004 10:09
> An: pgsql-general(at)postgresql(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Travers | 2004-02-12 13:08:38 | Re: I want to use postresql for this app, but... |
Previous Message | Shridhar Daithankar | 2004-02-12 11:02:37 | Re: error when executing dynamic commands with transaction |