Re: Re: Moving Postgresql 9.1 instance from FreeBSD 9.0 machine to FreeBSD 10.2 - Mailing list pgsql-general

From Jim Nasby
Subject Re: Re: Moving Postgresql 9.1 instance from FreeBSD 9.0 machine to FreeBSD 10.2
Date
Msg-id 567737F0.90402@BlueTreble.com
Whole thread Raw
In response to Re: Moving Postgresql 9.1 instance from FreeBSD 9.0 machine to FreeBSD 10.2  (Amitabh Kant <amitabhkant@gmail.com>)
List pgsql-general
On 12/20/15 3:43 PM, Amitabh Kant wrote:
> Just did a transfer without a hitch on a 1 TB (approx) production
> database . Everything is working fine. Saved a ton of time and
> complications.

Note that that would not work if there were any binary incompatibilities
between the two systems. Something like big vs little endian would be an
obvious example. Postgres would detect all the obvious examples of this
and refuse to start. One thing I'm not sure about is if there were
different locals installed on the two machines.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com


pgsql-general by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Unique index problem
Next
From: Jim Nasby
Date:
Subject: Re: Test disk reliability (or HGST HTS721010A9E630 surprisingly reliable)