Re: Editing contrib modules which are loaded by default?

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.

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.

Jim Nasby-2 wrote:
>
> Isn't there an option when you install on windows that controls what
> contrib stuff is included?
>
> Anyway, it's pretty simple to add plpgsql back in using CREATE LANGUAGE.
>
> On Nov 25, 2006, at 5:16 PM, novnov wrote:
>
>>
>> I hadn't checked and the page you pointed to here was different
>> from the one
>> you pointed to on the other list
>> (http://www.postgresql.org/docs/techdocs.22) I've experimented a
>> bit and
>> have been able to see what template0 consists of by creating a db
>> based on
>> it. It lacks the ref to the lang plpgsql. So if I made a new
>> template1 from
>> template0, all new dbs would lack that lang. That leaves me with a
>> different
>> starting point for my new dbs but still not what I want.
>>
>> Seems like this core config aspect of postgres could be a little
>> simpler to
>> manage...anyways I'll figure it out, your pointers have helped.
>>
>>
>>
>> novnov wrote:
>>>
>>> Hi Ray - yes I read and checked in to your advice on the other
>>> list but I
>>> posted here because the procedure looked a little complex and
>>> possibly
>>> risky for a newbie like me. Rather than ask you for a simpler way
>>> to go, I
>>> figured I'd post here and see what I came up with...and knew of
>>> course
>>> that you'd probably be on this list too. I'm just hoping that
>>> there is a
>>> way to clear those spurious (to me) entries without the level of
>>> hacking
>>> that the article you pointed me to entailed.
>>>
>>>
>>>
>>> Raymond O wrote:
>>>>
>>>> On 25 Nov 2006 at 14:24, novnov wrote:
>>>>
>>>>> In all of postgres 8.1.4 (windows) databases I create there are a
>>>>> bunch of cube and g_cube functions added to the db. If these are
>>>>> not
>>>>> needed, is there a simple way to make sure that they are not
>>>>> added to
>>>>> new databases?
>>>>
>>>> As I was telling you on the pgadmin-support list, these are copied
>>>> from the template1 database whenever you create a new database - the
>>>> CREATE DATABASE command effectively duplicates template1.
>>>>
>>>> To prevent these functions from appearing in your new databases,
>>>> remove them from template1.
>>>>
>>>> Have a look at the docs:
>>>> http://www.postgresql.org/docs/8.1/interactive/manage-ag-
>>>> createdb.html
>>>>
>>>> --Ray O'Donnell
>>>>
>>>> --------------------------------------------------------------------
>>>> --
>>>>
>>>> Raymond O'Donnell
>>>> Director of Music, Galway Cathedral, Galway, Ireland
>>>> rod(at)iol(dot)ie
>>>> --------------------------------------------------------------------
>>>> --
>>>>
>>>>
>>>>
>>>> ---------------------------(end of
>>>> broadcast)---------------------------
>>>> TIP 1: if posting/reading through Usenet, please send an appropriate
>>>> subscribe-nomail command to majordomo(at)postgresql(dot)org so
>>>> that your
>>>> message can get through to the mailing list cleanly
>>>>
>>>>
>>>
>>>
>>
>> --
>> View this message in context: http://www.nabble.com/Editing-contrib-
>> modules-which-are-loaded-by-default--tf2705139.html#a7543210
>> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>>
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 1: if posting/reading through Usenet, please send an appropriate
>> subscribe-nomail command to majordomo(at)postgresql(dot)org so that
>> your
>> message can get through to the mailing list cleanly
>>
>
> --
> Jim Nasby jim(at)nasby(dot)net
> EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
>
>
>
> ---------------------------(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#a7583745
Sent from the PostgreSQL - general mailing list archive at Nabble.com.