Hi there,
strange thing, but every time I need to (re)install the tablefunc, I run into
problems.
I am using the Kyngchaos packages for Snow Leopard. Everything works smoothly,
until I arrive at the additional, manual installation of tablefunc.
I downloaded the correct version of the postgres
Stefan Schwarzer writes:
> I downloaded the correct version of the postgres package (8.4.3), and
> followed the indicated guidelines:
>
> You can build extensions for Postgres without fully rebuilding Postgres. For
> the "contrib" extensions in
Hi there,
strange thing, but every time I need to (re)install the tablefunc, I run into
problems.
I am using the Kyngchaos packages for Snow Leopard. Everything works smoothly,
until I arrive at the additional, manual installation of tablefunc.
I downloaded the correct version of the postgres
Stefan Schwarzer writes:
> ERROR: could not load library "/usr/local/pgsql/lib/tablefunc.so":
> dlopen(/usr/local/pgsql/lib/tablefunc.so, 10): no suitable image
> found. Did find:
> /usr/local/pgsql/lib/tablefunc.so: mach-o, but wrong
> architecture
That's very curious.
The following does basically the same thing, but I find it a bit
easier
to follow:
sudo -u postgres /usr/local/pgsql/bin/pgsql < tablefunc.sql
Thanks for that. Looks indeed less complicated! :-)
But not yet success for me:
I did re-start, just to be sure.
for postgres:
./configu
On Mon, Jan 25, 2010 at 04:05:57PM +0100, Stefan Schwarzer wrote:
> Guess I'd need to do this as/with postgres user/role.
Yup, or at least somebody with superuser rights. Try "\du" in psql.
> But really not
> sure how this goes. Thought it should be something like this:
>
> sudo su - po
But when I do this I get this error message:
Makefile:17: ../../src/Makefile.global: No such file or directory
Makefile:18: /contrib/contrib-global.mk: No such file or directory
make: *** No rule to make target `/contrib/contrib-global.mk'.
Stop.
What is the problem? What
Stefan Schwarzer writes:
> I deleted involuntarily my tablefunc functions in my database. Now, I
> am trying to get them back into it again. But without success.
> I am running Mac OS X, 10.5, with postgres 8.3.1 and have used the
> Kyngchaos packages. It seems to me that before I succeeded i
Hi there,
I deleted involuntarily my tablefunc functions in my database. Now, I
am trying to get them back into it again. But without success.
I am running Mac OS X, 10.5, with postgres 8.3.1 and have used the
Kyngchaos packages. It seems to me that before I succeeded in doing
this from w