Difference between revisions of "System Administrator's Guide/Enabling Plpgsql"

From Mahara Wiki
Jump to navigation Jump to search
(Created page with "If you are using an old version of Postgres (8.1 or 8.2), and you are installing or upgrading to Mahara 1.5, you will need to ensure the plpgsql language is available in your Mah…")
 
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
If you are using an old version of Postgres (8.1 or 8.2), and you are installing or upgrading to Mahara 1.5, you will need to ensure the plpgsql language is available in your Mahara database. The following commands can be used in your psql database client:
+
If your database has been configured without plpgsql as a trusted language, and you are installing or upgrading to Mahara 1.5, you will need to ensure the plpgsql language is available in your Mahara database.
 +
 
 +
== Enable PL/pgSQL using the psql terminal client ==
 +
 
 +
The following commands can be used in your psql database client:
  
 
  CREATE TRUSTED LANGUAGE plpgsql;
 
  CREATE TRUSTED LANGUAGE plpgsql;
Line 6: Line 10:
 
Replace <mahara_db_user> with the user that mahara connects to the db with.
 
Replace <mahara_db_user> with the user that mahara connects to the db with.
  
(Works on Red Hat Enterprise Linux 5.8, PostgreSQL 8.1.23)
+
(Tested on Red Hat Enterprise Linux 5.8, PostgreSQL 8.1.23)
 +
 
 +
== Enable PL/pgSQL using the createlang program ==
 +
 
 +
Alternatively, you can use the createlang utility that comes with Postgres.  For instructions on how to use createlang, see the relevant page of the Postgres manual: Version [http://www.postgresql.org/docs/8.3/static/app-createlang.html 8.3]
 +
[http://www.postgresql.org/docs/8.4/static/app-createlang.html 8.4]
 +
[http://www.postgresql.org/docs/9.0/static/app-createlang.html 9.0]

Latest revision as of 15:49, 27 March 2012

If your database has been configured without plpgsql as a trusted language, and you are installing or upgrading to Mahara 1.5, you will need to ensure the plpgsql language is available in your Mahara database.

Enable PL/pgSQL using the psql terminal client

The following commands can be used in your psql database client:

CREATE TRUSTED LANGUAGE plpgsql;
GRANT USAGE ON LANGUAGE plpgsql TO <mahara_db_user>;

Replace <mahara_db_user> with the user that mahara connects to the db with.

(Tested on Red Hat Enterprise Linux 5.8, PostgreSQL 8.1.23)

Enable PL/pgSQL using the createlang program

Alternatively, you can use the createlang utility that comes with Postgres. For instructions on how to use createlang, see the relevant page of the Postgres manual: Version 8.3 8.4 9.0