Peer authentication failed for user "geo" geodjango tutorial postgresql error

Question

I'm starting the geodjango tutorial. I've copy and past everythings but I still get the error.

django.db.utils.OperationalError: FATAL:  Peer authentication failed for user "geo"

I'm new to geodjango and postgresql and postgis. I've made a fresh install of postgresql and postgis.

I create the geo user as in the doc.

$ sudo su - postgres
$ createuser --createdb geo
$ exit

I can't figure how to resolve it.

Here is my settings:

DATABASES = {
'default': {
     'ENGINE': 'django.contrib.gis.db.backends.postgis',
     'NAME': 'geodjango',
     'USER': 'geo',
     # 'HOST': 'localhost', I tried this but didn't work
     # 'PASSWORD': '***', I tried it too using a password but didn't work
 }

}

BoumTAC BoumTAC · Accepted Answer · 2015-05-18T00:00:07

So I find a solution, the geodjango tutorial is not working.

sudo -i -u postgres

then:

psql

then:

CREATE USER username;

ALTER ROLE username WITH CREATEDB;

ALTER USER username WITH ENCRYPTED PASSWORD 'password';

and I have my settings like this:

DATABASES = {
'default': {
     'ENGINE': 'django.contrib.gis.db.backends.postgis',
     'NAME': 'geodjango',
     'USER': 'username',
     'HOST': 'localhost',
     'PASSWORD': '****',
 }

}

Peer authentication failed for user "geo" geodjango tutorial postgresql error

2 Answers