| From: | Pascal CROZET <pascal(dot)crozet(at)qualis-consulting(dot)com> |
|---|---|
| To: | "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org> |
| Subject: | migrate from PG 9.5 to PG 12 or more |
| Date: | 2021-10-19 15:41:50 |
| Message-ID: | PAXP251MB00981D48C6A39C9607449A71A0BD9@PAXP251MB0098.EURP251.PROD.OUTLOOK.COM |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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/> •
_________________________________
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2021-10-19 21:33:04 | Re: [PATCH] doc/queries.sgml: add missing comma |
| Previous Message | Alvaro Herrera | 2021-10-19 15:16:44 | Re: ALTER TABLE ... SET DATA TYPE removes statistics |