Re: Pg_upgrade remote copy

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Pg_upgrade remote copy
Дата
Msg-id 20150829182827.GC28360@momjian.us
обсуждение исходный текст
Ответ на Pg_upgrade remote copy  (AI Rumman <rummandba@gmail.com>)
Ответы Re: Pg_upgrade remote copy  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
On Fri, Aug 28, 2015 at 10:34:38PM -0700, AI Rumman wrote:
> Hi,
> 
> In pg_upgrade, how about adding a feature to copy data directory over network.
> That is, we can run pg_upgrade from our new host, where old host will be a
> remote machine.
> We can add two parameters - oldhost and if it is used, pg_upgrade will identify
> the old host as remote and instead of local copy, it will use remote copy.
> 
> What do you think about it?

Well, you could NFS-mount the remote directory and have it work that
way.  One complexity is that you need to start/stop the old and new
servers, so doing something without NFS is going to be vary hard.

I think it is much simpler to just copy the old clsuter to the remote
server and run pg_upgrade in --link mode on the remote server.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + Everyone has their own god. +



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: On-demand running query plans using auto_explain and signals
Следующее
От: Jeff Janes
Дата:
Сообщение: buffer README is out of date