Re: 2.5TB Migration from SATA to SSD disks - PostgreSQL 9.2

Поиск
Список
Период
Сортировка
От David Gibbons
Тема Re: 2.5TB Migration from SATA to SSD disks - PostgreSQL 9.2
Дата
Msg-id CAHZ9er=GYNErPb5W3svZeWQomBatzs94K0Y9e3tDyenz8fb02A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 2.5TB Migration from SATA to SSD disks - PostgreSQL 9.2  (Patrick B <patrickbakerbr@gmail.com>)
Ответы Re: 2.5TB Migration from SATA to SSD disks - PostgreSQL 9.2  (Steve Crawford <scrawford@pinpointresearch.com>)
Re: 2.5TB Migration from SATA to SSD disks - PostgreSQL 9.2  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Список pgsql-general
Дерево обсуждения

So is that really possible? Just copy the data between folders? if so, i'll probably chose option 2!!!
Even that is 2.5TB I don't think the copy will take longer than 20 minutes... and I'd still be able to perform reads...

I'll do some test to see if option 2 can be done :)

Thanks !!! :D


 
You can actually reduce the time more by pre-syncing to the new location. 
something like:

rsync -va /var/lib/pgsql/ /var/lib/pgsql2/
service postgres stop
rsync -va /var/lib/pgsql/ /var/lib/pgsql2/

The second rsync will only copy the deltas from the first, it still has to go in and determine what needs to be copied/what changed but the bulk of it can be prepared/migrated before the actual downtime window.


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

Предыдущее
От: Brent Douglas
Дата:
Сообщение: Re: PG_MODULE_MAGIC issue with small extension
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: What limits Postgres performance when the whole database lives in cache?