Postgres Pro
Downloads
Home   >   mailing lists

Thread: PostgreSQL upgrade from 9.6 to 10.13

PostgreSQL upgrade from 9.6 to 10.13

From
Ramesh Maddi
Date:
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

Re: PostgreSQL upgrade from 9.6 to 10.13

From
"David G. Johnston"
Date:
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. 

Re: PostgreSQL upgrade from 9.6 to 10.13

From
Olivier Gautherot
Date:
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 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

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