Can't connect to Postgres database with Bitnami Django stack

Question

I keep running into the problem of not being able to connect to the database:

psycopg2.OperationalError: could not connect to server: No such file or directory

Is the server running locally and accepting connections on Unix domain socket “/tmp/.s.PGSQL.5432”?

I did some reading and it seems like it’s a quite common problem that most people fix by checking that the port is correct, ie from changing 5432 to 5433 in their setup.py. But this does not seem to be my problem – in the /opt/bitnami/postgresql directory i see .s.PGSQL.5432. I can log into psql and it seems to work correctly. I think the default database name is postgresql, but i also tried it with the one called djangostack and it didn’t work either. My database information in Django's setting.py looks like this:

DATABASES = {
'default': {
    'ENGINE': 'postgresql_psycopg2', #'django.db.backends.', # Add 'postgresql_psycopg2', 'postgresql', 'mysql', 'sqlite3' or 'oracle'.
    'NAME': 'postgres',                      # Or path to database file if using sqlite3.
    'USER': 'postgres',                      # Not used with sqlite3.
    'PASSWORD': 'bitnami',                  # Not used with sqlite3.
    'HOST': '',                      # Set to empty string for localhost. Not used with sqlite3.
    'PORT': '5432',                      # Set to empty string for default. Not used with sqlite3.
}

I look in the /tmp/ directory and there isn’t anything there, hidden or otherwise. Is there supposed to be? Does anyone know what I’m doing wrong? I stupidly overwrote the original example project so I can’t see what the settings were there.

Thanks a lot, Alex

Sorry I should add that I'm running the Bitnami Django 1.3 AMI on ec2, as seen at the bottom of [this link](http://bitnami.org/stack/djangostack). — Alex S, May 23 '11 at 19:55
Did you install postgresql? Did you start it? Can you connect to it with a client like pgsql or pgAdmin? — Eelke, May 23 '11 at 20:10
Yes, it is installed by default with the AMI, and I can connect to it with psql. — Alex S, May 23 '11 at 21:58

score 3 · Accepted Answer · edited May 23 '17 at 12:04

3

So the PostgreSQL socket is in /opt/bitnami/postgresql but your libpq (the C library that psycopg2 wraps) is looking for the socket in /tmp, right? Try changing the HOST setting to point at the proper socket location:

'default': {
    'ENGINE':   'postgresql_psycopg2',
    'NAME':     'postgres',
    'USER':     'postgres'
    'PASSWORD': 'bitnami',
    'HOST':     '/opt/bitnami/postgresql/.s.PGSQL.5432', # <-------
    'PORT':     '5432',
}

Or this:

'default': {
    'ENGINE':   'postgresql_psycopg2',
    'NAME':     'postgres',
    'USER':     'postgres'
    'PASSWORD': 'bitnami',
    'HOST':     '/opt/bitnami/postgresql', # <-------
    'PORT':     '5432',
}

And you might want to change the the PostgreSQL password too.

edited May 23 '17 at 12:04

Community

1
1

answered May 23 '11 at 20:31

mu is too short

426,620
70
833
800

1

According to [Django docs](http://docs.djangoproject.com/en/dev/ref/settings/#std:setting-DATABASES) the socket-as-hostname feature only works for MySQL. Set HOST to 127.0.0.1 instead to bypass sockets. – Mel May 23 '11 at 20:40
@Mel: The documentation often presents a simplified version of reality. I found a few examples that indicate that socket-as-hostname also works with psycopg2. The docs seem to be a little ambiguous about what happens when you use a path for the host with PostgreSQL. – mu is too short May 23 '11 at 20:55
1

Thanks mu, setting "host" to "/opt/bitnami/postgresql" fixed it. – Alex S May 23 '11 at 22:02
If you are using the BitNami AMI setting 'HOST': '127.0.0.1', should also work. – kaysa Aug 25 '11 at 10:01

ivewor · Answer 2 · 2022-08-05T06:19:51.517

1

Change the Hostname to localhost

   DATABASES = {
        "default": {
            "ENGINE": "django.db.backends.postgresql_psycopg2",
            "NAME": "DB",
            "USER": "USER",
            "PASSWORD": "PASS",
            "HOST": "localhost",
            "PORT": "5432",
        }
    }

Also, don't connect it with default postgres user. Create a new one.

edited Aug 05 '22 at 06:19

answered Aug 05 '22 at 06:15

ivewor

11
1
4

score 0 · Answer 3 · answered Apr 26 '22 at 09:37

0

Restart postgresql by using the command

sudo /opt/bitnami/ctlscript.sh restart postgresql

it worked for me

answered Apr 26 '22 at 09:37

Jasir

653
8
17

Can't connect to Postgres database with Bitnami Django stack

3 Answers3

Linked