Re: RPM package question

Thanks for this Tom.

----- "Tom Lane" <tgl@sss.pgh.pa.us> wrote:
> John Gardner <john.gardner@tagish.co.uk> writes:
> > We've got an application to install on PostgreSQL 8.2 and the
> > requirements say "Please make sure that PL/pgsql and
> FuzzyStringMatch
> > library is installed."
>
> > Can anyone tell me which RPM packages contain these?
>
> Hmm, I'm pretty sure Devrim's packages split up the same way mine do,
> so the answer should be -server and -contrib respectively.  Which
> you've got.  You probably just haven't activated them in your current
> database.  To install plpgsql you say "CREATE LANGUAGE plpgsql".
> To install a contrib module you run its defining SQL script, which if
> memory serves is under /usr/share/pgsql/contrib/ (if not, rpm -ql
> on the -contrib RPM will tell you where they are).
>
>             regards, tom lane