By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,767 Members | 1,033 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,767 IT Pros & Developers. It's quick & easy.

Migrating 7.1.3 to 7.3.4 problem

P: n/a
JM
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

Nov 22 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
You may need to whip out a set of RH 7.3 disks to install that OS first,
then pg 7.1.3, then you can dump that data out to 7.3.

If you have a choice, go to 7.4, it imports from 7.1.3 directly, ie.:

on the 7.4.1 machine:

pg_dumpall -h oldboxwith7.1.3|psql template1

will generally work, whereas for 7.1.3 to 7.3, you'll have to dump the
7.1.3 database with the 7.1.3 pg_dumpall, copy it to somewhere the 7.3
box can get to it and psql it into that box. And it seems like some of
the issues I had migrating to 7.3 went away with 7.4, but I can't remember
what they were right now. Need more donuts.

On Thu, 12 Feb 2004, JM wrote:
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

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

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 22 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.