Re: Postgres UPGRADE from 9.2 to 9.4

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

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 

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

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