Thread: Create extension tablefunc fails with "wrong ELF class: ELFCLASS32"

Create extension tablefunc fails with "wrong ELF class: ELFCLASS32"

From
Jan Mechtel
Date:
Our webhoster moved us to a 64Bit CentOS. I installed postgresql-9.1.3 from 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.

Jan

Re: Create extension tablefunc fails with "wrong ELF class: ELFCLASS32"

From
John R Pierce
Date:
On 10/20/12 10:21 AM, Jan Mechtel wrote:
> Our webhoster moved us to a 64Bit CentOS. I installed postgresql-9.1.3
> from source.

instead, you probably should have installed postgres from the
yum.postgresql.com repository.

something like this...



# rpm -Uvh
http://yum.postgresql.org/9.1/redhat/rhel-6-x86_64/pgdg-centos91-9.1-4.noarch.rpm

...
# yum install postgresql91-server postgresql91-contrib
...
# chkconfig postgresql-9.1 on
# service postgresql-9.1 initdb
## (tweak /var/lib/pgsql/9.1/postgresql.conf and pg_hba.conf to suit)
# service postgresql-9.1 start


--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast