Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
docs:postgresql_upgrade [2018/12/28 14:13]
hawk [Preparation]
docs:postgresql_upgrade [2018/12/28 14:14] (current)
hawk [Preparation]
Line 27: Line 27:
 Make sure that nothing can access your database. Easiest and fastest way to do this is to temporarily change database ports for both old and new cluster. Make sure that nothing can access your database. Easiest and fastest way to do this is to temporarily change database ports for both old and new cluster.
  
-Edit pg_hba.conf of PostgreSQL 10 cluster and temporarily set authentication method to //trust// so you don't have to provide password during upgrade. Also update postgresql.conf for PostgreSQL 11 so it matches your old configuration.+Edit pg_hba.conf of PostgreSQL 10 cluster and temporarily set authentication method to //trust// so you don't have to provide password during upgrade.
 =====Upgrade===== =====Upgrade=====
  
© TLD Linux