Hi, I was working with pg7.1 on RedHat 7.1. But, unfortunately, while updating RedHat9 I forgot to pg_dump my data files written with pg7.1.
pg7.1 doesnt seem to compile on redhat 9. so i installed pg7.3.4 on RedHat 9, copied my earlier files into the new data directory under pgsql and tried to open it. But, I got the error message Version mismatch, I just changed the contents of PG_VERSION to 7.3 from 7.1 and then I get this new message that PG_CONTROL_VERSION mismatch exists. Some pointers point to contrib/pg_resetxlog...could somebody give me more precise information where to find this utility and would it work for my situation. Any help is greatly appreciated ! PIYUSH. ---------------------------(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