Django Postgresql syncdb error

Question

When I run python manage.py syncdb, I get this error:

OperationalError: could not translate host name "localhost" to address: nodename nor servname provided, or not known

my settings.py file looks like this:

if "IS_STAGING" in os.environ or "IS_PRODUCTION" in os.environ:
    import dj_database_url
    DATABASES = {'default':dj_database_url.config(default='postgres://localhost')}
else:
    DATABASES = {
        'default': {
            'ENGINE': 'django.db.backends.postgresql_psycopg2', # Add 'postgresql_psycopg2', 'mysql', 'sqlite3' or 'oracle'.
            'NAME': 'test',                      # Or path to database file if using sqlite3.
            # The following settings are not used with sqlite3:
            'USER': 'test',
            'PASSWORD': 'test',
            'HOST': 'localhost',                      # Empty for localhost through domain sockets or '127.0.0.1' for localhost through TCP.
            'PORT': '',                      # Set to empty string for default.
        }
    }

you try just putting in 127.0.0.1 or leaving that line blank? — Mike McMahon
– Mike McMahon, Commented Oct 19, 2013 at 3:44
glasslion, localhost is defined in my etc/hosts.txt file as: 127.0.0.1 localhost — vincenttian
– vincenttian, Commented Oct 19, 2013 at 3:47
nslookup localhost' returns: Server: 128.32.136.9 Address: 128.32.136.9#53 ** server can't find localhost: NXDOMAIN — vincenttian
– vincenttian, Commented Oct 19, 2013 at 3:48

Ashwin Balamohan · Accepted Answer · 2013-11-15 04:41:32Z

1

I've had this error multiple times. If you're trying to connect to a local database, your best bet is to leave the host as an empty string:

'HOST': ''

If that doesn't work, the following should:

'HOST': '127.0.0.1'

answered Nov 15, 2013 at 4:41

Ashwin Balamohan

3,3322 gold badges27 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Django Postgresql syncdb error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related