Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx> writes: >> If you copy the *entire* data tree (data, xlog, clog, any outside >> tablespaces), and use exactly the same Postgres executables at both >> ends, then it should pretty much Just Work. > Thats what i feared from the begining. (some connection between the data dir > and the executable, really, why does the executable need to be exactly the > same, > if we are talking about minor postgresql upgrade 7.4.12->7.4.13?) Well, a minor version update won't in itself break anything; what would break things is changing certain build options (such as integer-datetimes) or switching to a different architecture (such as x86 -> x86_64). regards, tom lane