Re: Make & Install contrib/tablefunc Problems

Поиск
Список
Период
Сортировка
От Stefan Schwarzer
Тема Re: Make & Install contrib/tablefunc Problems
Дата
Msg-id BCCAAFAB-0368-4D8D-A1A2-C0AA2B38C5C4@grid.unep.ch
обсуждение исходный текст
Ответ на Re: Make & Install contrib/tablefunc Problems  (Sam Mason <sam@samason.me.uk>)
Ответы Re: Make & Install contrib/tablefunc Problems  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
> 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:
    ./configure (with parameters)
    make

for tablefunc:
    make
    sudo make install

and then:
    sudo -u postgres /usr/local/pgsql/bin/psql -d geodataportal < contrib/
tablefunc/tablefunc.sql
    could not identify current directory: Permission denied
    could not identify current directory: Permission denied
    SET
    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
    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
    ERROR:  relation "tablefunc_crosstab_2" already exists
    ERROR:  relation "tablefunc_crosstab_3" already exists
    ERROR:  relation "tablefunc_crosstab_4" already exists
    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
    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
    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
    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
    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
    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
    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
    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
    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

Besides the fact that I have no idea what is going on, if I look
through my database as indicated (-d geodataportal) I don't see any
"table_func" functions.

Thanks for any help.

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: Postgres Host
Следующее
От: S Arvind
Дата:
Сообщение: Re: Postgres Host