[ADMIN] Add tablefunc modules to Postgresql 9.1

[Kevin Duffy]

Hello All:

I am attempting to move a database that was/is running on Postgresql under
Windows
to Postgresql under Fedora 16.

On the Windows server the database had the tablefunc module installed.
I did this a long time ago and have no idea or recollection how it was done.

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.

So I drop and recreate the database as per these instructions:
http://www.postgresql.org/docs/9.1/static/contrib.html
It says to execute CREATE EXTENSION tablefunc in a fresh database.

This gives me an error message as follows:
ERROR:could not open extension control file
"usr/share/pgsql/extension/tablefunc.control":
No such file or directory

Your kind assistance is requested.

Best Regards

KD

[Tom Lane]

Post by Kevin Duffy
When I restored the database on the Fedora server, I got many errors
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

[Kevin Duffy]

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

Post by Tom Lane

Post by Kevin Duffy
When I restored the database on the Fedora server, I got many errors
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