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 <[email protected]> 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 < > [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>>: >> >> 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. >
