in postgresql 6.4.2, we have tried a pgdump and pgdumpall and then restore. 
 something in the script file bombs every time.  i would like to move the 
data and index files from 6.4.2 to 6.5.3.  could i re-create the database 
manually in 6.5.3, manually create the tables and indexes, and then 
physically COPY the files from the old 6.4.2 directory into the new 
database directory in 6.5.3?  are the file structures the same for 6.5.3?

is there a better way to do this migration?  the pgdump isn't working.

jt kirkpatrick

Reply via email to