Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL upgrade from 9.6 to 10.13 - Mailing list pgsql-admin

From Olivier Gautherot
Subject Re: PostgreSQL upgrade from 9.6 to 10.13
Date
Msg-id CAJ7S9TWXqYipEcghs92zioZCDUK0T99Nm_q71n3cv+4EA72rOA@mail.gmail.com
Whole thread Raw
In response to PostgreSQL upgrade from 9.6 to 10.13  (Ramesh Maddi <mymail.ramesh@gmail.com>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Raj kumar
Date:
Subject: Re: Time taken for 1TB postgres restore - RTO
Next
From: Mayur Mundada
Date:
Subject: Re: Encryption password for Backup