Re: Question about pg_upgrade from 9.2 to X.X

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Perumal Raj <perucinci(at)gmail(dot)com>
Cc: Sergei Kornilov <sk(at)zsrv(dot)org>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Question about pg_upgrade from 9.2 to X.X
Date: 2019-03-04 22:32:21
Message-ID: 20190304223221.GQ29584@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Mon, Mar 04, 2019 at 02:21:11PM -0800, Perumal Raj wrote:
> 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

I don't think it's default.
But was probably installed by running some SQL script.

It tentatively sounds safe to me to drop, but you should take a backup and
inspect and double check your pg_dump output and output of "begin; drop schema
pgreorg cascade".

Justin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ben Chobot 2019-03-05 01:08:04 Re: master-> 2 hot standbys
Previous Message Perumal Raj 2019-03-04 22:21:11 Re: Question about pg_upgrade from 9.2 to X.X

Browse pgsql-hackers by date

  From Date Subject
Next Message Karl O. Pinc 2019-03-04 22:33:47 Patch to document base64 encoding
Previous Message Perumal Raj 2019-03-04 22:21:11 Re: Question about pg_upgrade from 9.2 to X.X