Re: Editing contrib modules which are loaded by default?

From: novnov <novnovice(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Editing contrib modules which are loaded by default?
Date: 2006-11-28 18:01:06
Message-ID: 7584226.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I'm sure I didn't do something properly but the point is, as a newbie, none
of it is obvious.

However I'm going to have to try again, as the setup for pgsql 8.1 does not
seem to have a way to turn off the cube contrib modules. They are not listed
anywhere in the setup console.

Or I will try to find and execute the contrib module uninstall scripts.

It's all a lot of work.

Joshua D. Drake wrote:
>
> On Tue, 2006-11-28 at 09:38 -0800, novnov wrote:
>> I imagine that there is a step in the windows install that allows one to
>> select contrib modules. I don't recall. I didn't add these contrib
>> modules,
>> so they must be included by default, which frankly seems pretty dumb.
>>
>> I've tried to follow the instructions on the pgsql site for replacing
>> template1 with template0. It gets pretty complicated, because you can't
>> delete a template db, so you have to convert it to a non-template, then
>> delete, then proceed with the replacement. So, I did all of that and as
>> far
>> as I could tell all steps succeded. But a new db still contains all of
>> the
>> unwanted functions and types.
>
> If your new db containted all of the unwanted functions, then you didn't
> do *something* correctly.
>
>>
>> I will resort to ininstalling pgsql and reinstalling. I have to say that
>> this aspect of pgsql is rather difficult to work with. Starting with why
>> cube and g_cube modules are included by default and ending with the
>> difficulty of manipulating template1...it could be easier for newbies.
>> I'll
>> make a request on the pgAdmin list to see if these kinds of settings
>> can't
>> be somehow included in that tool.
>
> There are uninstall scripts for all contrib modules that you could have
> used.
>
> Sincerely,
>
> Joshua D. Drake
>
> --
>
> === The PostgreSQL Company: Command Prompt, Inc. ===
> Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
> Providing the most comprehensive PostgreSQL solutions since 1997
> http://www.commandprompt.com/
>
> Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
>

--
View this message in context: http://www.nabble.com/Editing-contrib-modules-which-are-loaded-by-default--tf2705139.html#a7584226
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2006-11-28 18:03:26 Re: How to implement backup protocol
Previous Message Mark Jensen 2006-11-28 17:55:44 Including unique users in huge data warehouse in Postgresql...