Re: [GENERAL] Postgres UPGRADE from 9.2 to 9.4

[Patrick B]

>
>
> 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