Re: Postgres UPGRADE from 9.2 to 9.4

On 9/6/2016 4:47 PM, Patrick B wrote:
> 1 - upgrade master server
> 2 - by performing #1 - the slaves would become unused (streaming
> replication wouldn't work)
> 3 - Setup new slave running Postgres 9.4
> 4 - dump the db to the new server
>

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.


--
john r pierce, recycling bits in santa cruz