Re: Postgresql 7.4 migration to (partially) new disks - Mailing list pgsql-admin

From Tom Lane
Subject Re: Postgresql 7.4 migration to (partially) new disks
Date
Msg-id 23601.1158516913@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgresql 7.4 migration to (partially) new disks  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-admin
Achilleas Mantzios <achill@matrix.gatewaynet.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

pgsql-admin by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: Postgresql 7.4 migration to (partially) new disks
Next
From: Michael Fuhr
Date:
Subject: Re: real and effective user ids must match