Re: Moving database install to new SAN

Поиск
Список
Период
Сортировка
От Chris Hoover
Тема Re: Moving database install to new SAN
Дата
Msg-id 1d219a6f0709201110r603e1d4dg8cc4f514201a65ab@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Moving database install to new SAN  (Andrzej Zawadzki <zawadaa@gmail.com>)
Ответы Re: Moving database install to new SAN  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-admin


> 2. copy whole data directory over to new SAN
If database is big, then I think that is much faster to copy running
database
to new SAN.
Then stop postgres and rsync what was changed - but this will be probably
only a few files.


I believe if you do this, you will not get a function database in the end.  There is a lot of data that is held in memory/buffers that may not be flushed to the disks.  You have no guarantee you will get this data with this method.

Either shut the database down and cold copy it, or setup replication using Slony to move the data in a "hot"mode.

HTH,

Chris

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

Предыдущее
От: "Chris Hoover"
Дата:
Сообщение: Re: How to update from 8.1 to 8.2 ?
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Moving database install to new SAN