Talk:Create Moodle site database
Note: You are currently viewing documentation for Moodle 2.0. Up-to-date documentation for the latest stable version is available here: Create Moodle site database.
I think the 1.5 warning could be shoved to the bottom of the page. --chris collman 11:06, 1 May 2009 (UTC)
Comment from Andrew Davis copied from MDLSITE-1241:
We provide some instructions on how to set up a Postgresql database at https://docs.moodle.org/en/Create_Moodle_site_database#PostgreSQL
psql -c "create database moodle with encoding 'unicode';" -U moodleuser template1
The above commands fails for me saying:
psql: FATAL: Ident authentication failed for user "moodleuser"
The document says that may happen and if it does I should do this:
psql -c "create database moodle with template=template1 encoding = 'unicode' owner = moodleuser location = '/var/mydata';"
When I do that I get the following:
WARNING: LOCATION is not supported anymore HINT: Consider using tablespaces instead.
I removed the location part of the command then it seemed to work fine. Is there are reason we're even bothering to specify a location in the fallback command when we dont in the primary command?
Im using postgres 8.4