This question has probably been asked and answered before, and if so, I would appreciate if that could be pointed out to me.
I have googled this point quite a bit, but I want to be very sure as to what I am doing before performing this task:
I need to move my current postresql 9.1 database to a new server. This new server will be taking over on that account and the other "turned off".
I need to do this live without, as much as possible, disturbing the users or having to shut down operation.
I also need to move without any possibility of data-loss (anything being written during the move).
Like I said above, if this is already answered/laid out anywhere, I would much appreciate being pointed to it.
I am currently running on Gentoo Linux and will be moving to a Ubuntu server.