Обсуждение: CREATELANG in pgsql 7.3.2 failing

Поиск
Список
Период
Сортировка

CREATELANG in pgsql 7.3.2 failing

От
R Blake
Дата:
hi,

i've successfully installed Postgresql 7.3.2 on Mac OSX 10.2.4, and can
access/administer as necessary

except, i can't seem to CREATELANG, specifically plpgsql .....

the command:

        createlang --pglib=/usr/local/pgsql/lib --dbname=apache_auth plpgsql

simply returns:

ERROR:  Load of file /usr/local/pgsql/lib/plpgsql.dylib failed: no error
message available
createlang: language installation failed


my LOG file has nothing further:

...
LOG:  database system is ready
ERROR:  Load of file /usr/local/pgsql/lib/plpgsql.dylib failed: no error
message available



"no error message" is not very helpful  :-(

i tried a clean install -- all went without a hitch .....

anyone have any suggestions here?


thanks!

richard

Re: CREATELANG in pgsql 7.3.2 failing

От
R Blake
Дата:
you have some sort of a problem?

<http://archives.postgresql.org/pgsql-admin/>
"This is a general discussion area for users pertaining to the
administration, compilation and installation of PostgreSQL"

--On Sunday, March 16, 2003 11:39 AM -0700 Rich Burgi
<ts-rrb@orem.verio.net> wrote:

> who cares.... get me off this list!!!!!!
>
> On Sun, 16 Mar 2003, R Blake wrote:
>
>> hi,
>>
>> i've successfully installed Postgresql 7.3.2 on Mac OSX 10.2.4, and can
>> access/administer as necessary
>>
>> except, i can't seem to CREATELANG, specifically plpgsql .....
>>
>> the command:
>>
>>         createlang --pglib=/usr/local/pgsql/lib --dbname=apache_auth
>>         plpgsql
>>
>> simply returns:
>>
>> ERROR:  Load of file /usr/local/pgsql/lib/plpgsql.dylib failed: no error
>> message available
>> createlang: language installation failed
>>
>>
>> my LOG file has nothing further:
>>
>> ...
>> LOG:  database system is ready
>> ERROR:  Load of file /usr/local/pgsql/lib/plpgsql.dylib failed: no error
>> message available
>>
>>
>>
>> "no error message" is not very helpful  :-(
>>
>> i tried a clean install -- all went without a hitch .....
>>
>> anyone have any suggestions here?
>>
>>
>> thanks!
>>
>> richard
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 3: if posting/reading through Usenet, please send an appropriate
>> subscribe-nomail command to majordomo@postgresql.org so that your
>> message can get through to the mailing list cleanly
>>
>




--------------------------------------
R Blake
blakers <at> mac <dot> com
--------------------------------------
MacOSX ..... because Windows sux.
--------------------------------------

Re: CREATELANG in pgsql 7.3.2 failing

От
"A.Bhuvaneswaran"
Дата:
>         createlang --pglib=/usr/local/pgsql/lib --dbname=apache_auth plpgsql
>
> simply returns:
>
> ERROR:  Load of file /usr/local/pgsql/lib/plpgsql.dylib failed: no error
> message available
> createlang: language installation failed

I suspect that plpgsql.dylib wasn't there in /usr/local/pgsql/lib/, try to
locate the file and specify --pglib param appropriately.

regards,
bhuvaneswaran


Re: CREATELANG in pgsql 7.3.2 failing

От
R Blake
Дата:
thanks for your reply, but, nope, that was the first thing i checked.

definitely there, and a freshly built copy ....

and, from what i've tracked down , that would've generated a "file not
found" error ....

i'm suspicious -- but still tumped -- of that "no error message available"
message ...

richard

--On Monday, March 17, 2003 10:53 AM +0530 "A.Bhuvaneswaran"
<bhuvansql@myrealbox.com> wrote:

>>         createlang --pglib=/usr/local/pgsql/lib --dbname=apache_auth
>>         plpgsql
>>
>> simply returns:
>>
>> ERROR:  Load of file /usr/local/pgsql/lib/plpgsql.dylib failed: no error
>> message available
>> createlang: language installation failed
>
> I suspect that plpgsql.dylib wasn't there in /usr/local/pgsql/lib/, try
> to  locate the file and specify --pglib param appropriately.
>
> regards,
> bhuvaneswaran
>