Arch Linux

arch_enemy

Member

From: Ukraine, Mykolayiv

Registered: 2008-06-12

Posts: 18

postgresql and tablefunc

i've just installed fresh arch linux (yesterday), have done full system upgrade, configured my DE, at least installed postgres.
so, i'm unable to restore my databases from backup, i'm getting errors like:
......ERROR:  could not access file "$libdir/tablefunc": No such file or directory ........... bla bla

and looks like there is no such library in postgres lib dir?..

# find / -name "*tablefunc*"
/usr/share/doc/postgresql/html/tablefunc.html

#pacman -Qsi postgres
local/libpqxx 3.0-1
    C++ client API for PostgreSQL
local/pgadmin3 1.10.0-2
    A comprehensive design and management interface for PostgreSQL database
local/postgresql 8.3.7-3
    A sophisticated object-relational DBMS
local/postgresql-libs 8.3.7-2
    Libraries for use with PostgreSQL

i'll be appreciated for any help! thnx

foutrelis

Developer

From: Athens, Greece

Registered: 2008-07-28

Posts: 705

Website

Re: postgresql and tablefunc

Judging by this thread, you need to install postgresql-contrib.

arch_enemy

Member

From: Ukraine, Mykolayiv

Registered: 2008-06-12

Posts: 18

Re: postgresql and tablefunc

Judging by this thread, you need to install postgresql-contrib.

great! it helps!

thanks a lot!