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

Thanks Andreas .. I thought of going the replication way .. But having done
a sample run couple of hours ago, it seems it will work out without making
any changes . Will update this thread once I have done the final run .

Amitabh

On Sunday 20 December 2015, Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
wrote:

> Read the doc about Replikation. I think you can simply set up the New
> machine AS streaming Replikation slave and promote it than AS master - with
> no downtime.
>
> Am 20. Dezember 2015 02:50:57 MEZ, schrieb Amitabh Kant <
> amitabhkant(at)gmail(dot)com
> <javascript:_e(%7B%7D,'cvml','amitabhkant(at)gmail(dot)com');>>:
>>
>> Hi
>>
>> I have a Postgresql 9.1 instance running on FreeBSD 9.0 (64 bit). The
>> machine is now running out of space and no extra hard disk can be added to
>> the machine. I am planning to move the instance to another machine which is
>> running FreeBSD 10.2 (64 bit) with the same Postgresql version.
>>
>> One idea is to take a dump and transfer the data, which is my fallback
>> plan. The other is to simply copy over the data directory since the
>> postgresql version is same (64 bit OS with PG 9.1) on both machine. This
>> will reduce a lot of down time as the data is around 1 TB .
>>
>> Old Machine: FreeBSD 9.0 (64 bit) with Postgresql 9.1 (UFS file system)
>>
>> New Machine: FreeBSD 10.2 (64 bit) with Postgresql 9.1 (UFS file system)
>>
>> The directory structure and others hardware would remain the same in both
>> machine, apart from a increased capacity of hard disk and RAM in the new
>> machine.
>>
>> Just wondering if anybody has already done such a move or has any
>> suggestions if I should or should not go the directory copy route?
>>
>>
>> Thanks
>>
>> Amitabh
>>
>
> --
> Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail
> gesendet.
>