Re: Postgres UPGRADE from 9.2 to 9.4 - Mailing list pgsql-general

From Patrick B
Subject Re: Postgres UPGRADE from 9.2 to 9.4
Date
Msg-id CAJNY3iu8oV5bkri26Ni78VdOHWFNhD5Ptd9eb5hz5Mj2PsLKDQ@mail.gmail.com
Whole thread Raw
In response to Re: Postgres UPGRADE from 9.2 to 9.4  (John R Pierce <pierce@hogranch.com>)
Responses Re: Postgres UPGRADE from 9.2 to 9.4  (Venkata B Nagothi <nag1010@gmail.com>)
List 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 by date:

Previous
From: John R Pierce
Date:
Subject: Re: Postgres UPGRADE from 9.2 to 9.4
Next
From: Nguyễn Trần Quốc Vinh
Date:
Subject: Re: Materialized view auto refresh