Subject: Re: Regarding query on the postgresql upgrade
Cc: pgsql-admin@lists.postgresql.org
References: 
 <CAGeQtUsfuCkMxjYGqtnTyJm0o-rOe2OX4uwTSZ7BVE9cH+aXGQ@mail.gmail.com>
 <8148c916-87ea-e36c-763e-ad7ed9311e34@gmx.net>
 <CABUevEwhP-U08yDGuPN9fftDNNiuBkstj9cwWoF2GNSHm0XfXQ@mail.gmail.com>
From: Thomas Kellerer <shammat@gmx.net>
Message-ID: <fd13570e-58ff-9be6-c9e7-339473deadea@gmx.net>
Date: Thu, 15 Oct 2020 13:24:30 +0200
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23)
 Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666
MIME-Version: 1.0
In-Reply-To: 
 <CABUevEwhP-U08yDGuPN9fftDNNiuBkstj9cwWoF2GNSHm0XfXQ@mail.gmail.com>
Content-Type: text/plain; charset=utf-8
Content-Language: de-DE
Content-Transfer-Encoding: quoted-printable
Precedence: bulk

Magnus Hagander schrieb am 15.10.2020 um 12:27:
>     Ramesh Penuballi schrieb am 15.10.2020 um 10:27:
>     > We=C2=A0 are planning to upgrade the postgres version from 9.2.13 =
to
>     > 9.4.25 by keeping the support version of Atlassian in mind.
>     >
>     > But to proceed the same in production, we have tried to run the
>     > pgdump command to take the backup of all the databases and getting
>     > the below error when we tried to take the dump of Eazybi database
>     > which is not present on our stage environment.
>
>     For a minor version upgrade you only need to install the new binarie=
s and restart the Postgres service.
>
>
> 9.2 to 9.4 is not a minor upgrade though. It's a major upgrade, so
> either pg_dump/pg_restore or pg_upgrade will need to be used.

A shoot. For some reason I thought it was 9.4.13 to 9.4.25

Sorry for the noise.