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 outils
Le 19/10/2021 à 17:41, >
pascal.crozet (par Internet, dépôt
pgsql-docs-owner+m63745-354...@lists.postgresql.org) a écrit :
|
Re: migrate from PG 9.5 to PG 12 or more
CONVERS Yann - DREAL Auvergne-Rhône-Alpes/CIDDAE/SIG Tue, 19 Oct 2021 22:20:22 -0700
- ALTER TABLE ... SET ... nikolai.berkoff
- Re: ALTER TABLE... Euler Taveira
- Re: ALTER T... Michael Paquier