In article <1130088693.16135.2.camel@localhost>, Chris <postgresql@xxxxxxxxxxxx> wrote: >How can I get my data from this 7.4 data directory into my 8.0.3 fresh >install? Bring up a copy of 7.4 long enough to run pg_dumpall. Then load the dump into 8.0.3. -- http://www.spinics.net/yosemite/ ---------------------------(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