Postgres Pro
Downloads
Home   >   mailing lists

Re: Question about pg_upgrade from 9.2 to X.X - Mailing list pgsql-general

From Perumal Raj
Subject Re: Question about pg_upgrade from 9.2 to X.X
Date
Msg-id CALvqh4o-8-3NOrYkPA_RweSfMMT21pJ-70U0Qz6WgDB7ng4dLA@mail.gmail.com
Whole thread Raw
In response to Re: Question about pg_upgrade from 9.2 to X.X  (Justin Pryzby <pryzby@telsasoft.com>)
Responses Re: Question about pg_upgrade from 9.2 to X.X  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-general
Tree view
Hi Justin

Does it mean that these functions are default and came with 9.2 ? 
I am wondering how these functions are created in the DB as the library($libdir/pg_reorg)  is not exists in system 

Note:
My schema name is reorg not pg_reorg




On Mon, Mar 4, 2019 at 1:45 PM Justin Pryzby <pryzby@telsasoft.com> wrote:
On Mon, Mar 04, 2019 at 01:37:30PM -0800, Perumal Raj wrote:
> I could see bunch of functions under reorg schema.

Those functions are the ones preventing you from upgrading.
You should drop schema pg_reorg cascade.
You can run it in a transaction first to see what it will drop.
But after the upgrade, you can CREATE EXTENSION pg_repack, which is a fork of
pg_reorg, which is itself no longer maintained.

Justin

pgsql-general by date:

Previous
From: Julie Nishimura
Date:
Subject: master-> 2 hot standbys
Next
From: Justin Pryzby
Date:
Subject: Re: Question about pg_upgrade from 9.2 to X.X