From: | Olivier Gautherot <ogautherot(at)gautherot(dot)net> |
---|---|
To: | Ramesh Maddi <mymail(dot)ramesh(at)gmail(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: PostgreSQL upgrade from 9.6 to 10.13 |
Date: | 2020-07-17 11:58:38 |
Message-ID: | CAJ7S9TWXqYipEcghs92zioZCDUK0T99Nm_q71n3cv+4EA72rOA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Ramesh,
Le ven. 17 juil. 2020 à 06:31, Ramesh Maddi <mymail(dot)ramesh(at)gmail(dot)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 vers**ion: 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Mayur Mundada | 2020-07-18 15:13:34 | Re: Encryption password for Backup |
Previous Message | Raj kumar | 2020-07-17 11:14:41 | Re: Time taken for 1TB postgres restore - RTO |