Request a Demo
Home   >   mailing lists

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

From David G. Johnston
Subject Re: PostgreSQL upgrade from 9.6 to 10.13
Date
Msg-id CAKFQuwb-NaaO7cviRrcRsQDMRJJLr6-9nkFM2fO=QoRMi+pRbQ@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
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. 

pgsql-admin by date:

Previous
From: Ramesh Maddi
Date:
Subject: PostgreSQL upgrade from 9.6 to 10.13
Next
From: Raj kumar
Date:
Subject: Time taken for 1TB postgres restore - RTO