Re: Editing contrib modules which are loaded by default? - Mailing list pgsql-general

From novnov
Subject Re: Editing contrib modules which are loaded by default?
Date
Msg-id 7584226.post@talk.nabble.com
Whole thread Raw
In response to Re: Editing contrib modules which are loaded by default?  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Editing contrib modules which are loaded by default?  ("Raymond O'Donnell" <rod@iol.ie>)
Re: Editing contrib modules which are loaded by default?  (Richard Huxton <dev@archonet.com>)
List 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.


pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: AIX and getaddrinfo (was Re: Upgrade problem)
Next
From: Mark Jensen
Date:
Subject: Including unique users in huge data warehouse in Postgresql...