Talk: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)

PostgreSQL

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