Re: Add tablefunc modules to Postgresql 9.1

[Kevin Duffy <kevind0718@xxxxxxxxx>]

I actually figured this one out, with a little help from the web.
I kind'a figured that I needed to install or add postgresql-contrib.
And I figured yum would be involved.

This posting got me the rest of the way.
http://joysofprogramming.com/install-postgresql-contrib-fedora-rhel/

Key point being

$ yum search postgresql-contrib

postgresql-contrib.i686 : Contributed modules distributed with PostgreSQL

$ yum install postgresql-contrib

Thanks for your swift reply on the weekend.

Best 

KD

On Sun, Feb 5, 2012 at 5:25 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

Kevin Duffy <kevind0718@xxxxxxxxx> writes:
> When I restored the database on the Fedora server, I  got many errors
> containing the following:
> ERROR: could not access the file "$libdir/tablefunc": No such file or
> directory

> Tells me that tablefunc is not available.

You should install the postgresql-contrib RPM to get that.

                       regards, tom lane