django.db.utils.OperationalError：无法连接到服务器：没有这样的文件或目录

问题描述：

我settings.py中的数据库设置为低于django.db.utils.OperationalError：无法连接到服务器：没有这样的文件或目录

DATABASES = { 
    'default': { 
     'ENGINE': 'django.db.backends.postgresql_psycopg2', 
     'NAME': 'dbname', 
     'USER': 'postgres', 
     'PASSWORD': 'postgres', 
     'HOST': '', 
     'PORT':'8081', 
    } 
}

但在运行时蟒迁移manage.py我我收到错误django.db.utils.OperationalError：无法连接到服务器：没有这样的文件或目录

Traceback (most recent call last): 
    File "/home/vivekpradhan/joker/basket/local/lib/python3.4/site-packages/django/db/backends/base/base.py", line 130, in ensure_connection 
    self.connect() 
    File "/home/vivekpradhan/joker/basket/local/lib/python3.4/site-packages/django/db/backends/base/base.py", line 119, in connect 
    self.connection = self.get_new_connection(conn_params) 
    File "/home/vivekpradhan/joker/basket/local/lib/python3.4/site-packages/django/db/backends/postgresql_psycopg2/base.py", line 176, in get_new_connection 
    connection = Database.connect(**conn_params) 
    File "/home/vivekpradhan/joker/basket/local/lib/python3.4/site-packages/psycopg2/__init__.py", line 164, in connect 
    conn = _connect(dsn, connection_factory=connection_factory, async=async) 
psycopg2.OperationalError: could not connect to server: No such file or directory 
    Is the server running locally and accepting 
    connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.8081"? 


The above exception was the direct cause of the following exception: 

Traceback (most recent call last): 
    File "manage.py", line 10, in <module> 
    execute_from_command_line(sys.argv) 
    File "/home/vivekpradhan/joker/basket/local/lib/python3.4/site-packages/django/core/management/__init__.py", line 338, in execute_from_command_line 
    utility.execute() 
    File "/home/vivekpradhan/joker/basket/local/lib/python3.4/site-packages/django/core/management/__init__.py", line 330, in execute 
    self.fetch_command(subcommand).run_from_argv(self.argv) 
    File "/home/vivekpradhan/joker/basket/local/lib/python3.4/site-packages/django/core/management/base.py", line 393, in run_from_argv 
    self.execute(*args, **cmd_options) 
    File "/home/vivekpradhan/joker/basket/local/lib/python3.4/site-packages/django/core/management/base.py", line 444, in execute 
    output = self.handle(*args, **options) 
    File "/home/vivekpradhan/joker/basket/local/lib/python3.4/site-packages/django/core/management/commands/migrate.py", line 93, in handle 
    executor = MigrationExecutor(connection, self.migration_progress_callback) 
    File "/home/vivekpradhan/joker/basket/local/lib/python3.4/site-packages/django/db/migrations/executor.py", line 19, in __init__ 
    self.loader = MigrationLoader(self.connection) 
    File "/home/vivekpradhan/joker/basket/local/lib/python3.4/site-packages/django/db/migrations/loader.py", line 47, in __init__ 
    self.build_graph() 
    File "/home/vivekpradhan/joker/basket/local/lib/python3.4/site-packages/django/db/migrations/loader.py", line 182, in build_graph 
    self.applied_migrations = recorder.applied_migrations() 
    File "/home/vivekpradhan/joker/basket/local/lib/python3.4/site-packages/django/db/migrations/recorder.py", line 59, in applied_migrations 
    self.ensure_schema() 
    File "/home/vivekpradhan/joker/basket/local/lib/python3.4/site-packages/django/db/migrations/recorder.py", line 49, in ensure_schema 
    if self.Migration._meta.db_table in self.connection.introspection.table_names(self.connection.cursor()): 
    File "/home/vivekpradhan/joker/basket/local/lib/python3.4/site-packages/django/db/backends/base/base.py", line 162, in cursor 
    cursor = self.make_debug_cursor(self._cursor()) 
    File "/home/vivekpradhan/joker/basket/local/lib/python3.4/site-packages/django/db/backends/base/base.py", line 135, in _cursor 
    self.ensure_connection() 
    File "/home/vivekpradhan/joker/basket/local/lib/python3.4/site-packages/django/db/backends/base/base.py", line 130, in ensure_connection 
    self.connect() 
    File "/home/vivekpradhan/joker/basket/local/lib/python3.4/site-packages/django/db/utils.py", line 97, in __exit__ 
    six.reraise(dj_exc_type, dj_exc_value, traceback) 
    File "/home/vivekpradhan/joker/basket/local/lib/python3.4/site-packages/django/utils/six.py", line 658, in reraise 
    raise value.with_traceback(tb) 
    File "/home/vivekpradhan/joker/basket/local/lib/python3.4/site-packages/django/db/backends/base/base.py", line 130, in ensure_connection 
    self.connect() 
    File "/home/vivekpradhan/joker/basket/local/lib/python3.4/site-packages/django/db/backends/base/base.py", line 119, in connect 
    self.connection = self.get_new_connection(conn_params) 
    File "/home/vivekpradhan/joker/basket/local/lib/python3.4/site-packages/django/db/backends/postgresql_psycopg2/base.py", line 176, in get_new_connection 
    connection = Database.connect(**conn_params) 
    File "/home/vivekpradhan/joker/basket/local/lib/python3.4/site-packages/psycopg2/__init__.py", line 164, in connect 
    conn = _connect(dsn, connection_factory=connection_factory, async=async) 
django.db.utils.OperationalError: could not connect to server: No such file or directory 
    Is the server running locally and accepting 
    connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.8081"?

任何帮助将提前我在ubantu OS工作有帮助的感谢。

你确定'postresql'是您的服务器上运行？ – ozgur

不确定。我是django的新手，并且第一次将我的数据库设置从sqllite更改为postgresql。 –

你应该在你的设备上安装并运行postgresql服务器。 – ozgur

答

此步骤为我工作停用的virtualenv如果有。

pyenv deactivate

安装所需的库。

sudo apt-get install libpq-dev python-dev

安装PostgreSQL。

sudo apt-get install postgresql postgresql-contrib

启动PSQL壳。

sudo -u postgres psql

设置通过输入以下命令，将被提示在PSQL壳密码postgres用户密码。完成后按Control + D退出。

\password postgres

创建新的数据库用户称为django_user。

sudo -u postgres createuser django_user

转到PSQL壳。

sudo -u postgres psql

创建数据库，并将其命名django_db。

CREATE DATABASE django_db;

设置django_user密码。

ALTER USER django_user WITH PASSWORD '<password>';

授予特权正常。

GRANT ALL PRIVILEGES ON DATABASE django_db TO django_user;

退出PSQL壳和激活的virtualenv。

pyenv activate <virtualenv>

安装psycopg2包。

pip install psycopg2

编辑Django项目settings.py如下。

数据库= { '缺省'：{ '发动机'： 'django.db.backends.postgresql_psycopg2'， 'NAME'： 'django_db'， 'USER'： 'django_user'， '密码' ： ''， 'HOST'： '本地主机'， 'PORT'： '5432'， } }
初始化分贝。

python manage.py migrate

启动Django项目，看看是否一切工作正常。

python manage.py runserver 0.0.0.0:8000

做=）

开始=>

答

看起来PostgreSQL根本没有运行。尝试运行

sudo service postgresql start

它显示postgresql：无法识别的服务 –

你是如何安装它的？ – Oli

“pip install psycopg2”in my virtualenv –

django.db.utils.OperationalError：无法连接到服务器：没有这样的文件或目录

相关推荐