Re: Pg_upgrade remote copy

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Pg_upgrade remote copy
Дата
Msg-id 20150902231539.GC23640@momjian.us
обсуждение исходный текст
Ответ на Re: Pg_upgrade remote copy  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: Pg_upgrade remote copy  (AI Rumman <rummandba@gmail.com>)
Список pgsql-hackers
On Wed, Sep  2, 2015 at 04:50:32PM -0300, Alvaro Herrera wrote:
> Bruce Momjian wrote:
> > On Fri, Aug 28, 2015 at 10:34:38PM -0700, AI Rumman wrote:
> 
> > > 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.
> 
> > 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.
> 
> Couldn't it run pg_basebackup as a first step?

Yes.  I was thinking it would be simpler to just shut down the server
and copy it, but pg_basebackup would allow the server to be up during
the copy.

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



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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Horizontal scalability/sharding
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: DBT-3 with SF=20 got failed