Re: migrate from PG 9.5 to PG 12 or more

2021-10-19 Thread CONVERS Yann - DREAL Auvergne-Rhône-Alpes/CIDDAE/SIG
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,

migrate from PG 9.5 to PG 12 or more

2021-10-19 Thread Pascal CROZET
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