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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
