On Sat, Oct 20, 2012 at 11:00 AM, Jan Mechtel <jmechtel@xxxxxxxxxxxxx> 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. Sorry, I don't really know what this means. They just copied the folder, or the migration was more involved than that? Did you install 9.1.3 from source after the migration, or before the migration and then the installed binaries were migrated? > > 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 Yes, I'm referring to your installation of 9.1.3. tablefunc is a "contrib" module, and it is not installed by default, i.e. if you just run "make install" from the root of the source tree, it won't be installed. You have to do something else, like "make install-world", or going to the contrib or contrib/tablefunc directories and running "make install" from there. So it is possible you recompiled the main pgsql executables and libraries on 64-bit and overwrite the 32 bit versions with the new ones, but accidentally did not recompile tablefunc and so inherited the old version. > 2. Would I need to "uninstall" postgresql-9.1.3 somehow before running the > install again? You could probably get away with just doing a make clean, then redoing configure and make, and then doing "make install" only on contrib. But, If your current installation has become a confusing mixture of 32 bit and 64 bit binaries, it would probably be best to uninstall it and start from scratch to avoid additional confusion. If the original install was from source using the defaults, uninstalling it just means removing the directories: /usr/local/pgsql/include /usr/local/pgsql/share /usr/local/pgsql/lib /usr/local/pgsql/bin Of course you want to make sure you have a good backup of everything before doing anything. Cheers, Jeff -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
