On Sat, Oct 20, 2012 at 10:33 AM, Jan Mechtel <jmechtel@gmail.com> wrote:
> Our webhoster moved us to a 64Bit CentOS. I installed postgresql-9.1.3 from
> source.
Did you also install contrib from the same source?
>
> I run into trouble when trying to create the tablefunc extension
>
> b2blogin_mailrocket=# create extension tablefunc;
> ERROR: could not load library "/home/b2blogin/lib/postgresql/tablefunc.so":
> /home/b2blogin/lib/postgresql/tablefunc.so: wrong ELF class: ELFCLASS32
>
> On google I didn't only find some clues, that this seems related to 64bit
> vs. 32bit.
>
> Please help or point me in the right direction.
It looks like your tablefunc is left over from a previous build/install.
Had you previously used the same source tree to install tablefunc
under 32 bit? If so, you should start from a fresh source tree; or
run "make clean" or "make maintainer-clean" before configuring and
building again.
Cheers,
Jeff