On Wed, Mar 06, 2019 at 09:44:16PM -0800, Perumal Raj wrote:
> Any pointers for pg_repack schema creation ?
With recent postgres, you should use just: "CREATE EXTENSION pg_repack", which
does all that for you.
> Will there be any impact in the future , Since i used --link option ?
You probably h
Awesome, thanks Sergei and Justin,
Finally, I am able to upgrade the DB from 9.2 to 9.6 successfully after
dropping Schema (reorg) without library issue.
Also , I have installed -Contrib. package for Version:10 and upgraded to
version 10.7 too.
On both the cases , I have used --link option and
On Tue, Mar 05, 2019 at 08:09:12AM -0800, Perumal Raj wrote:
> Thanks Sergei/Justin for the continues update.
>
> So reorg Schema might be created as part of some scripts prior to 9.2
> Version ?
I'm guessing they were probably created in 9.2.
> These are the functions in DB not the Extension. H
Thanks Sergei/Justin for the continues update.
So reorg Schema might be created as part of some scripts prior to 9.2
Version ?
These are the functions in DB not the Extension. However these functions
will not run as the associated libraries are not exists in System now (9.2)
and I hope no impact t
Hi
seems this is unpackaged extension, usually installed prior 9.1 release. Maybe
reorg even does not support "create extension" syntax. That was long ago and
project homepage is unavailable now. pg_repack documentation mention "support
for PostgreSQL 9.2 and EXTENSION packaging" as improvement
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 insta
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 wrote:
> On
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 upgra
Hi Justin
I could see bunch of functions under reorg schema.
AS '$libdir/pg_reorg', 'reorg_disable_autovacuum';
AS '$libdir/pg_reorg', 'reorg_get_index_keys';
AS '$libdir/pg_reorg', 'reorg_apply';
AS '$libdir/pg_reorg', 'reorg_drop';
AS '$libdir/pg_reorg', 'reorg_indexdef';
AS '$libdir/pg_reorg',
Thanks.Will decently try that option and keep you posted.
Thanks again for redirecting to right group.
Perumal Raju
On Sun, Mar 3, 2019, 6:51 AM Justin Pryzby wrote:
> Moving to -general list (-hackers is for development topics like proposed
> patches and patch reviews and beta testing and cr
Moving to -general list (-hackers is for development topics like proposed
patches and patch reviews and beta testing and crash reports).
On Thu, Feb 28, 2019 at 10:13:58AM -0800, Perumal Raj wrote:
> could not load library "$libdir/pg_reorg":
> ERROR: could not access file "$libdir/pg_reorg": No
11 matches
Mail list logo
