Horton

migrate from PG 9.5 to PG 12 or more

Pascal CROZET <pascal.crozet@qualis-consulting.com>

View thread View on postgr.es
From: Pascal CROZET <pascal.crozet@qualis-consulting.com>
To: "pgsql-docs@lists.postgresql.org" <pgsql-docs@lists.postgresql.org>
Date: 2021-10-19T15:41:50Z
Lists: pgsql-docs 
Hi PG experts,

During next year, I've the goal to migrate an instance of 4 databases from PostGreSql 9.5 to 12 or maybe more 14.
What's the best tools I've to use ? Do a simple pg_dumpall in text format can archive this goal ?
What other files more than pg_hba.conf and postgresql.conf do I need to checK ?
And what issues can I find during this upgrade ?



_________________________________

Cordialement, Pascal CROZET
DBA  - [cid:c58e7220-eb5f-452f-9c51-2b24b75b1f8f]
• www.qualis-consulting.com<http://www.qualis-consulting.com/> •

_________________________________

Commits

  1. Document that ALTER TABLE .. TYPE removes statistics