Thanks a lot, this worked. I read to detail the tablefunc.so and then go to the postgres-9.1.3/contrib/ and call make + make install there.
On 20 October 2012 20:02, Jan Mechtel <jmech...@gmail.com> wrote: > Thanks for the quick reply, > This could indeed be a solution since the webhosting migrated the old > folder I used for installation on 32bit. > > I am not very familar with linux, I'd like to ask for two clarifications: > >If so, you should start from a fresh source tree; or run "make clean" or > >"make maintainer-clean" before configuring and building again. > 1. You refer to my installation of postgresql-9.1.3 ? as far as I > understand the tablefunc I am trying to load is included there > > 2. Would I need to "uninstall" postgresql-9.1.3 somehow before running > the install again? > > Thanks, > > Jan > > > On 20 October 2012 19:54, Jeff Janes <jeff.ja...@gmail.com> wrote: > >> > >> On Sat, Oct 20, 2012 at 10:33 AM, Jan Mechtel <jmech...@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 > > > > >
