PostgreSQL

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

• 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:

Create database moodle owner moodleuser;

See also

• PostgreSQL home page
• Arguments in favour of PostgreSQL
• Using Moodle - Databases forum
• Wikipedia article on PostgerSQL
• Using Moodle Upgrading to 1.6 and may need to switch to PostgreSQL forum discussion