Re: Postgres UPGRADE from 9.2 to 9.4

Поиск
Список
Период
Сортировка
От Venkata B Nagothi
Тема Re: Postgres UPGRADE from 9.2 to 9.4
Дата
Msg-id CAEyp7J8+oNNePKMNQtST-5Dh9dypENM+pmxnd+ntffcNHU34+w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgres UPGRADE from 9.2 to 9.4  (Patrick B <patrickbakerbr@gmail.com>)
Ответы Re: Postgres UPGRADE from 9.2 to 9.4  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general

On Wed, Sep 7, 2016 at 10:43 AM, Patrick B <patrickbakerbr@gmail.com> wrote:

how large is the full database cluster?

if its only a few GB or whatever, and not grossly complex, pg_dumpall -h oldhost | psql -h newhost, is the simplest way to move a complete set of databases from an old server to a new. if there are large tables with millions of rows indexed, make sure you set maintenance_work_mem on the new server to 2GB before running this.


it's a full copy from the production, so it's 2.3TB 

Thats quite huge. pg_upgrade would be a better choice and yes, downtime is needed. You need to have the database shutdown all through the upgrade process.

How long it will take depends on type of Disks you have. It is definitely a lot faster than pg_dump/pg_restore.

Regards,
Venkata B N

Fujitsu Australia

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

Предыдущее
От: Nguyễn Trần Quốc Vinh
Дата:
Сообщение: Re: Materialized view auto refresh
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Postgres UPGRADE from 9.2 to 9.4