Re: Looking for Postgres upgrade Metrix

Thanks Adrian, David,

Basically , i want to upgrade few 9.X/8.X version DBs to some stable
version ( 10.X / 11.X ), At the same time with less down time.
So want to understand whether direct upgrade possible or not between major
releases .

Thanks,

On Wed, Jul 17, 2019 at 11:24 AM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 7/17/19 11:15 AM, Perumal Raj wrote:
> > Hi Team,
> >
> > Do we have any reference link which explain various upgrade path (
> > Direct / indirect) by using pg_upgrade or latest utility.
>
> https://www.postgresql.org/docs/11/backup.html
>
> What exactly are you trying to do?
>
> >
> > I hope pg_dump can be used from any lower version to Higher version.
>
> As long as you use the newer pg_dump to dump the older version.
>
> > Please correct me if I am wrong.
>
>
> >
> > Thanks,
> > Raj
> >
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>