Re: [Major version upgrade] pg_upgrade fails despite passing check mode

2021-10-26 Thread Bruce Momjian
On Mon, Oct 25, 2021 at 07:52:13AM +0900, Abhishek Bhola wrote: > Thanks, let me try that out. > > But is there a way to know for sure if pg_upgrade will have any such problems? > Other than FDW's owner, any other things I should check before upgrading other > clusters? No. pg_upgrade's check mo

Re: [Major version upgrade] pg_upgrade fails despite passing check mode

2021-10-24 Thread Abhishek Bhola
Thanks, let me try that out. But is there a way to know for sure if pg_upgrade will have any such problems? Other than FDW's owner, any other things I should check before upgrading other clusters? Regards Abhishek Bhola On Sat, Oct 23, 2021 at 12:20 AM Laurenz Albe wrote: > On Fri, 2021-10-22

Re: [Major version upgrade] pg_upgrade fails despite passing check mode

2021-10-22 Thread Laurenz Albe
On Fri, 2021-10-22 at 17:11 +0900, Abhishek Bhola wrote: > postgres@dxxxpgs03:/D1/datadg/data13$ /usr/pgsql-13/bin/pg_upgrade -k > --check > --new-datadir='/D1/datadg/data13' --old-datadir='/D1/datadg/data' > --new-bindir='/usr/pgsql-13/bin' --old-bindir='/usr/pgsql-11/bin' > > *C

[Major version upgrade] pg_upgrade fails despite passing check mode

2021-10-22 Thread Abhishek Bhola
While upgrading from Postgres 11 to 13, the pg_upgrade passed the check mode postgres@dxxxpgs03:/D1/datadg/data13$ /usr/pgsql-13/bin/pg_upgrade -k --check --new-datadir='/D1/datadg/data13' --old-datadir='/D1/datadg/data' --new-bind$ r='/usr/pgsql-13/bin' --old-bindir='/usr/pgsql-11/bin