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>: >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.
