Forum OpenACS Q&A: PLPGSQL install for ACS

Collapse
1: PLPGSQL install for ACS
Posted by Sripathy Kasiviswanathan on 08/22/04 04:10 AM
Hi,

I installed OPenACS following the steps in the documentations. I am running postgres7.4.3.

When I try to set up "plpgsql" using cmd CREATELANG plpgsql template1, i get a error plpgsql file not found.

I am running Mandrake 9.1. I searched the file system for plpgsql.so and could not find it. I can find files plpgsql.h.

1. Can I download the plpgsql file to the lib folder and run from the current install or do I have to reinstall all (I would like to avoid this)?

When i tested "localhost:8000" a page with infomration about OPenACS opened with a message that "PLPGSQL" is not installed in the postgres.

2. Does this mean everything is correctly installed except for PLPGSQL?

Any help would be greatly appreciated.

thanks
Pathy

Collapse
2: Re: PLPGSQL install for ACS (response to 1)
Posted by George Essig on 08/22/04 08:46 PM
I think you need to install the Mandrake 9.1 postgresql-pl RPM.

George

Collapse
3: Re: PLPGSQL install for ACS (response to 1)
Posted by Sripathy Kasiviswanathan on 08/23/04 12:18 PM
George,
Thanks for the help. It is working fine now.

regards
Pathy