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

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

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