Re: Postgresql 7.4 migration to (partially) new disks

Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> 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