Hello....
While logged in as a postgres the following are the sequence of command given by me:
[postgres@ACS postgres]$ createuser acs
Shall the new user be allowed to create databases? (y/n) n
Shall the new user be allowed to create more new users? (y/n) n
CREATE USER
[postgres@ACS postgres]$ createdb acs
CREATE DATABASE
[postgres@ACS postgres]$ createlang plpgsql acs
createlang: cannot find the file ':/usr/local/pgsql/lib/plpgsql.so'
This file contains the call handler for PL/pgSQL. By default,
only PL/pgSQL is built and installed; other languages must be
explicitly enabled at configure time.
To install PL/Tcl, make sure the option --with-tcl is given to
configure, then recompile and install. To install PL/Perl use
--with-perl.
Then after logging as a acs user on my machine( a system account on my machine & also added as database user with same password.) i have given following command:
[acs@ACS acs]$cd /openacs-3.2.5/www/install
[acs@ACS acs]$ ./load-geo-tables >& data.log
[acs@ACS acs]$ grep ERROR data.log
I found no errors.Then..
[acs@ACS acs]$ cd ../doc/sql
[acs@ACS acs]$ psql -f load-data-model.sql >& model.log
[acs@ACS acs]$ grep ERROR *.log
I found the following errors:
******************
********************
*********************
psql:sdm.sql:671: ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
psql:sdm.sql:686: ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
psql:sdm.sql:702: ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
psql:sdm.sql:740: ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
psql:photodb.sql:15: ERROR: Function 'administration_group_add(unknown, unknown, unknown, unknown, unknown, unknown)' does not exist
psql:photodb.sql:146: ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
psql:photodb.sql:239: ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
psql:photodb.sql:250: ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
psql:photodb.sql:276: ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
psql:photodb.sql:296: ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
psql:photodb.sql:314: ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
psql:photodb.sql:323: ERROR: Relation 'dual' does not exist
psql:photodb.sql:329: ERROR: Relation 'dual' does not exist
Please Help Me.................
Regards,
--Pradeep
