hello Pascal,
I do it in 2020 from postgresql 9.6 to 12 .
I do with a shell linux script using pd_dump and pg_restore from a database save.
I first mount a new postgresql 12 server, prepare with new hard parameters in postgresql.conf, pg_hba.conf, .pgpass and all of the scripts and clients i need (pgadmin, phpadmin, shape2pgsql) with new IP.
When It's ok, with crontab i execute a script dump and restore from old server to new in a week-end and on monday morning when i see the new server with 1To data is ok i reverse IP of 2 serveurs.
take care to prepare the new server with care, and do test migration to prevent (without reverse IP) data loss or missconfiguration. You need to know how much time takes the process to be cool.
Have a good day!
Yann Convers Gestionnaire de l'infrastructure, des référentiels et des outilsDREAL Auvergne-Rhône-Alpes
Service Connaissance, Information, Développement Durable, Autorité Environnementale - Pole Système d Information Géographique Tél : 04 26 28 67 89 courriel : yann.convers@developpement-durable.gouv.fradresse de la boite d’unité : boite unitéPour toute commande interne de prestations, merci d utilisez le formulaire suivant : http://postgis-aura.projets.appli.i2/projects/demandes-de-prestations/issues/new
Adresse postale : DREAL Auvergne-Rhône-Alpes, CIDDAE - SIG 69453 LYON CEDEX 06 Adresse physique : 5 place Jules Ferry (immeuble Lugdunum - métro Brotteaux) - 69006 Lyon Standard : 04 26 28 60 00 Liens :Site Intranet Site Internet
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 •_________________________________