![]() Next post we will look at PostgreSQL a bit more, and following that we will start looking at MySQL and MariaDB. However, if you are a newer server or database administrator and only know MySQL, or you are a complete beginner admin and setting up Moodle for the first time, you should definitely stick with the traditional MySQL database, or consider the newer MariaDB option. For example: CREATE DATABASE 'scratch' WITH OWNER 'postgres' ENCODING UTF8 LCCOLLATE enUS.UTF-8 LCCTYPE enUS. Well, if you have PostgreSQL experts in your organisation, you already use PostgreSQL and love it, and you expect your Moodle site to be big and busy, and you need top performance, then PostgreSQL is a great choice! You are unlikely to regret it. Before installing Moodle, as all good little Moodlers know, one must create an empty database. 1 Answer Sorted by: 69 Yes, you can be more specific. There are also challenges if you are running Moodle and your database on different servers (which is quite likely in large installations). PostgreSQL handles this in a very different way to MySQL, and this is a potential pitfall for system administrators who are used to MySQL and now find themselves setting up a PostgreSQL server. In this blog we will show you how to deploy a highly available PostgreSQL cluster for the Moodle application. If considering PostgreSQL as your choice of database you definitely need to read this page:Īs well as the technical steps to install and use PostgreSQL with Moodle, there are very clear pointers to some of the issues you might encounter:Ĭlient Authentication is how PostgreSQL decides which user accounts can connect to which databases from which hosts. The e-learning platform Moodle supports PostgreSQL as an option for the underlying database. (Whilst Oracle and Microsoft SQL are counted in these five, they are by far the worst choice you can make, and should only be used if absolutely no other option exists for you). PostgreSQL is one of the five databases that is fully supported by Moodle. But should you use it for your Moodle site?
0 Comments
Leave a Reply. |