Обсуждение: PostgreSQL upgrade from 9.6 to 10.13
Hi Team,
We have postgreSQL 9.6 installed for our product using PostgreSQL interactive installer (postgresql-9.6.17-1-linux-x64.run) in Linux. Now we wanted to upgrade it to 10.13 using (postgresql-10.13-1-linux-x64.run). While doing it, getting below error.
Command I have used:
./postgresql-10.13-1-linux-x64.run --installer-language en --serviceaccount postgres --servicename postgres --datadir "/home/postgres/data" --prefix "/home/postgres" --serverport 5432 --mode unattended
Error:
The existing data directory (catalog version: 201608131) is not compatible with this server (catalog version: 201707211)
Can anyone have some insight on this? Thanks in advance.
- Ramesh
On Thursday, July 16, 2020, Ramesh Maddi <mymail.ramesh@gmail.com> wrote:
Hi Team,We have postgreSQL 9.6 installed for our product using PostgreSQL interactive installer (postgresql-9.6.17-1-linux-x64.run) in Linux. Now we wanted to upgrade it to 10.13 using (postgresql-10.13-1-linux-x64. run). While doing it, getting below error. Command I have used:./postgresql-10.13-1-linux-x64.run --installer-language en --serviceaccount postgres --servicename postgres --datadir "/home/postgres/data" --prefix "/home/postgres" --serverport 5432 --mode unattended Error:The existing data directory (catalog version: 201608131) is not compatible with this server (catalog version: 201707211)Can anyone have some insight on this? Thanks in advance
You cannot must update the software, the data needs to be made compatible with the new version.
You should start by reading the documentation here:
David J.
Hi Ramesh,
Le ven. 17 juil. 2020 à 06:31, Ramesh Maddi <mymail.ramesh@gmail.com> a écrit :
Hi Team,We have postgreSQL 9.6 installed for our product using PostgreSQL interactive installer (postgresql-9.6.17-1-linux-x64.run) in Linux. Now we wanted to upgrade it to 10.13 using (postgresql-10.13-1-linux-x64.run). While doing it, getting below error.Command I have used:./postgresql-10.13-1-linux-x64.run --installer-language en --serviceaccount postgres --servicename postgres --datadir "/home/postgres/data" --prefix "/home/postgres" --serverport 5432 --mode unattendedError:The existing data directory (catalog version: 201608131) is not compatible with this server (catalog version: 201707211)Can anyone have some insight on this? Thanks in advance.- Ramesh
You will hit this error with each major release: 9.5 to 9.6, 9.6 to 10, 10 to 11, etc. It is advisable to have your repository in seperate directories for each version: /home/postgres/9.6/data etc. pg_upgrade will take care of the dirty work.
Hope it helps
Olivier