Re: PostgreSQL upgrade from 9.6 to 10.13

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: PostgreSQL upgrade from 9.6 to 10.13
Дата
Msg-id CAKFQuwb-NaaO7cviRrcRsQDMRJJLr6-9nkFM2fO=QoRMi+pRbQ@mail.gmail.com
обсуждение исходный текст
Ответ на PostgreSQL upgrade from 9.6 to 10.13  (Ramesh Maddi <mymail.ramesh@gmail.com>)
Список pgsql-admin
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 по дате отправления:

Предыдущее
От: Ramesh Maddi
Дата:
Сообщение: PostgreSQL upgrade from 9.6 to 10.13
Следующее
От: Raj kumar
Дата:
Сообщение: Time taken for 1TB postgres restore - RTO