Re: Re: Moving Postgresql 9.1 instance from FreeBSD 9.0 machine to FreeBSD 10.2

From: Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>
To: Amitabh Kant <amitabhkant(at)gmail(dot)com>, Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
Cc: PGSQL Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Re: Moving Postgresql 9.1 instance from FreeBSD 9.0 machine to FreeBSD 10.2
Date: 2015-12-20 23:21:20
Message-ID: 567737F0.90402@BlueTreble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jim Nasby 2015-12-20 23:31:56 Re: Test disk reliability (or HGST HTS721010A9E630 surprisingly reliable)
Previous Message Jim Nasby 2015-12-20 23:17:45 Re: Unique index problem