Thread: postgresql on gentoo

I just installed postgresql on a new gentoo server using emerge and I would
like to add the citext module for a case insensitive text type. Emerge does
not have a citext option in postgresql or package.
Does anyone know how to get the citext into postgresql on gentoo and will
this break the next time I upgrade postgresql?

Sim Zacks wrote:
> I just installed postgresql on a new gentoo server using emerge and I
> would like to add the citext module for a case insensitive text type.
> Emerge does not have a citext option in postgresql or package. Does
> anyone know how to get the citext into postgresql on gentoo and will
> this break the next time I upgrade postgresql?

Not a direct answer.  I use PG on AMD64 Gentoo.  I wanted to use 8.0
before Gentoo incorporated it (don't know if they have yet or not.)  So
I downloaded the source and compiled it myself.  This is very easy to
do, as PG has very few dependencies.  So you might want to consider that
alternative.  You'll lose Gentoo's management of the PG installation,
but I don't find that a major issue.

--
Guy Rouillier

Sim Zacks wrote:

>I just installed postgresql on a new gentoo server using emerge and I would
>like to add the citext module for a case insensitive text type. Emerge does
>not have a citext option in postgresql or package.

No, because it's not part of the postgres tarball. But the Gentoo
ebuilds _do_ make and install everything that's in /contrib.

>Does anyone know how to get the citext into postgresql on gentoo and will
>this break the next time I upgrade postgresql?

Either download and compile it by hand as outlined in it's readme
(you'll have to untar your postgres sources from /usr/portage/distfiles
and copy it to the contrib dir), or write an ebuild to do it for you.

But if you're going to do a lot of stuff that involves compiling
postgres, I'd recommend taking postgres out of portage's control. That
way you've always got your own source tree to work from and you can
tweak configure however you want. Just be sure to configure with
--prefix=/usr/local, so it's out the way of your portage-installed stuff.

Matt

 It took me a while, but I finally figured out that the citext module did
not require a recompile, it just required all the compile information,
specifically the config.status file, which wasn't there.
After I extracted the sources and ran ./configure for postgresql, the
contrib module compiled very nicely.

I would think that emerge would keep all those sometimes needed
configuration files in the directory with the Makefile

"Sim Zacks" <sim@compulab.co.il> wrote in message
news:d0n25q$13pk$1@news.hub.org...
> I just installed postgresql on a new gentoo server using emerge and I
would
> like to add the citext module for a case insensitive text type. Emerge
does
> not have a citext option in postgresql or package.
> Does anyone know how to get the citext into postgresql on gentoo and will
> this break the next time I upgrade postgresql?
>
>