Re: Regarding query on the postgresql upgrade

On Thu, Oct 15, 2020 at 11:49 AM Thomas Kellerer <shammat(at)gmx(dot)net> wrote:

> Ramesh Penuballi schrieb am 15.10.2020 um 10:27:
> > We 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 binaries and
> restart the Postgres service.
>
> There is no need to use pg_dump/pg_restore in that case
>

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.

--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>