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 <andr...@a-kretschmer.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 < > amitabhk...@gmail.com > <javascript:_e(%7B%7D,'cvml','amitabhk...@gmail.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. >