Postgres Pro
Downloads
Home   >   mailing lists

Re: Looking for Postgres upgrade Metrix - Mailing list pgsql-general

From Perumal Raj
Subject Re: Looking for Postgres upgrade Metrix
Date
Msg-id CALvqh4q5WzaYQWcpuPTKi6+62vyxtxjajDKDPdOLFwUUyPnwrw@mail.gmail.com
Whole thread Raw
In response to Re: Looking for Postgres upgrade Metrix  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Looking for Postgres upgrade Metrix
List pgsql-general
Tree view
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.klaver@aklaver.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.klaver@aklaver.com

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Corrupt index stopping autovacuum system wide
Next
From: Alvaro Herrera
Date:
Subject: Re: Corrupt index stopping autovacuum system wide