pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedAdd tablefunc modules to Postgresql 9.1
3+ messages / 2 participants
[nested] [flat]
* Add tablefunc modules to Postgresql 9.1
@ 2012-02-05 00:48 Kevin Duffy <kevind0718@gmail.com>
2012-02-05 22:25 ` Re: Add tablefunc modules to Postgresql 9.1 Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: Kevin Duffy @ 2012-02-05 00:48 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Add tablefunc modules to Postgresql 9.1
2012-02-05 00:48 Add tablefunc modules to Postgresql 9.1 Kevin Duffy <kevind0718@gmail.com>
@ 2012-02-05 22:25 ` Tom Lane <tgl@sss.pgh.pa.us>
2012-02-05 22:48 ` Re: Add tablefunc modules to Postgresql 9.1 Kevin Duffy <kevind0718@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2012-02-05 22:25 UTC (permalink / raw)
To: Kevin Duffy <kevind0718@gmail.com>; +Cc: pgsql-admin
Kevin Duffy <kevind0718@gmail.com> 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Add tablefunc modules to Postgresql 9.1
2012-02-05 00:48 Add tablefunc modules to Postgresql 9.1 Kevin Duffy <kevind0718@gmail.com>
2012-02-05 22:25 ` Re: Add tablefunc modules to Postgresql 9.1 Tom Lane <tgl@sss.pgh.pa.us>
@ 2012-02-05 22:48 ` Kevin Duffy <kevind0718@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Kevin Duffy @ 2012-02-05 22:48 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
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@sss.pgh.pa.us> wrote:
> Kevin Duffy <kevind0718@gmail.com> 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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2012-02-05 22:48 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-02-05 00:48 Add tablefunc modules to Postgresql 9.1 Kevin Duffy <kevind0718@gmail.com>
2012-02-05 22:25 ` Tom Lane <tgl@sss.pgh.pa.us>
2012-02-05 22:48 ` Kevin Duffy <kevind0718@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox