Postgres Pro
Downloads
Home   >   mailing lists

migrate from PG 9.5 to PG 12 or more - Mailing list pgsql-docs

From Pascal CROZET
Subject migrate from PG 9.5 to PG 12 or more
Date
Msg-id PAXP251MB00981D48C6A39C9607449A71A0BD9@PAXP251MB0098.EURP251.PROD.OUTLOOK.COM
Whole thread Raw
In response to Re: ALTER TABLE ... SET DATA TYPE removes statistics  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-docs
Tree view
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  - 
• www.qualis-consulting.com •

_________________________________

Attachment

pgsql-docs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: ALTER TABLE ... SET DATA TYPE removes statistics
Next
From: Tom Lane
Date:
Subject: Re: [PATCH] doc/queries.sgml: add missing comma