PostgreSQL: Difference between revisions

Latest revision as of 10:05, 8 December 2011

PostgreSQL is one of the two databases that is fully supported by Moodle. A database is a required component of any Moodle installation.

Creating Moodle Database

These instructions assume that the database server and web server are on the same machine. If that is not the case you have some more work to do. See the PostgreSQL documentation for further details.

Log into the PostgreSQL command line client. The exact form depends on how your PostgreSQL is configured but will be something like:

$ psql -U postgres
Password for user postgres:

(enter the password for your 'postgres' user set during installation). After some preamble you should see the prompt postgres=#.

Create the user for the Moodle database and assign a password:

postgres=# create user moodleuser with password 'yourpassword';

...substituting a suitably strong password.

Create the database:

postgres=# create database moodle owner moodleuser;

@@ Line 1: / Line 1: @@
+{{Installing Moodle}}
 PostgreSQL is one of the two databases that is fully supported by Moodle. A database is a required component of any Moodle installation.
-PostgreSQL describes itself thus:
+== Creating Moodle Database ==
-"PostgreSQL is an object-relational database management system (ORDBMS) based on POSTGRES, Version 4.2, developed at the University of California at Berkeley Computer Science Department. POSTGRES pioneered many concepts that only became available in some commercial database systems much later.
+These instructions assume that the database server and web server are on the same machine. If that is not the case you have some more work to do. See the PostgreSQL documentation for further details.
-PostgreSQL is an open-source descendant of this original Berkeley code. It supports a large part of the SQL standard and offers many modern features:
+* Log into the PostgreSQL command line client. The exact form depends on how your PostgreSQL is configured but will be something like:
+<pre>
+$ psql -U postgres
+Password for user postgres:
+</pre>
+(enter the password for your 'postgres' user set during installation). After some preamble you should see the prompt ''postgres=#''.
+* Create the user for the Moodle database and assign a password:
+<pre>
+postgres=# create user moodleuser with password 'yourpassword';
+</pre>
+...substituting a suitably strong password.
+* Create the database:
+<pre>
+postgres=# create database moodle owner moodleuser;
+</pre>
-* complex queries
+== See also ==
-* foreign keys
-* triggers
-* views
-* transactional integrity
-* multiversion concurrency control
-Also, PostgreSQL can be extended by the user in many ways, for example by adding new
-* data types
+* [http://www.postgresql.org PostgreSQL home page]
-* functions
+* [[Arguments in favour of PostgreSQL]]
-* operators
+* [http://moodle.org/mod/forum/view.php?id=45 Using Moodle - Databases forum]
-* aggregate functions
+* [http://en.wikipedia.org/wiki/Postgres Wikipedia article on PostgerSQL]
-* index methods
+* Using Moodle [http://moodle.org/mod/forum/discuss.php?d=49195 Upgrading to 1.6 and may need to switch to PostgreSQL] forum discussion
-* procedural languages
-And because of the liberal license, PostgreSQL can be used, modified, and distributed by everyone free of charge for any purpose, be it private, commercial, or academic."
+[[Category:SQL databases]]
-PostgreSQL home page: http://www.postgresql.org/
+[[ja:PostgreSQL]]

Documentation

PostgreSQL: Difference between revisions

Latest revision as of 10:05, 8 December 2011

Creating Moodle Database

See also