SQLite to PostgreSQL问题[摇尾教程]
SQLite to PostgreSQL问题[摇尾教程]
提问于 2018-03-02 12:26:03
这是我第一次在heroku部署我的摇尾应用程序(我对此感到非常自豪:)。我正在学习本教程(参见下面的链接)：https://wagtail.io/blog/deploying-wagtail-heroku/
但在本教程中，我遇到了一个问题:当我在sqlite之间将数据库更改为PostgreSQL时。
问题是：
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 "/tmp/.s.PGSQL.5432"?我在mac 10.13.3上。Python和Anaconda。
以下是我所做的：
- 将base.py文件中的默认端口更改为5433，但不起作用(如本教程：https://vix.digital/insights/deploying-wagtail-production/)
- 试图找到并修改.conf文件，但我没有找到.
在此之前，没有安装以前的postgresql。我没有任何postgres服务器运行(我不知道如何检查它，但我被困在本教程的第一步.)。
谢谢你的帮助！)
整个终端响应
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "manage.py", line 12, in <module>
execute_from_command_line(sys.argv)
File "/Users/darkbook/anaconda3/lib/python3.6/site-packages/django/core/management/__init__.py", line 364, in execute_from_command_line
utility.execute()
File "/Users/darkbook/anaconda3/lib/python3.6/site-packages/django/core/management/__init__.py", line 356, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/Users/darkbook/anaconda3/lib/python3.6/site-packages/django/core/management/base.py", line 283, in run_from_argv
self.execute(*args, **cmd_options)
File "/Users/darkbook/anaconda3/lib/python3.6/site-packages/django/core/management/base.py", line 330, in execute
output = self.handle(*args, **options)
File "/Users/darkbook/anaconda3/lib/python3.6/site-packages/django/core/management/commands/migrate.py", line 83, in handle
executor = MigrationExecutor(connection, self.migration_progress_callback)
File "/Users/darkbook/anaconda3/lib/python3.6/site-packages/django/db/migrations/executor.py", line 20, in __init__
self.loader = MigrationLoader(self.connection)
File "/Users/darkbook/anaconda3/lib/python3.6/site-packages/django/db/migrations/loader.py", line 52, in __init__
self.build_graph()
File "/Users/darkbook/anaconda3/lib/python3.6/site-packages/django/db/migrations/loader.py", line 209, in build_graph
self.applied_migrations = recorder.applied_migrations()
File "/Users/darkbook/anaconda3/lib/python3.6/site-packages/django/db/migrations/recorder.py", line 65, in applied_migrations
self.ensure_schema()
File "/Users/darkbook/anaconda3/lib/python3.6/site-packages/django/db/migrations/recorder.py", line 52, in ensure_schema
if self.Migration._meta.db_table in self.connection.introspection.table_names(self.connection.cursor()):
File "/Users/darkbook/anaconda3/lib/python3.6/site-packages/django/db/backends/base/base.py", line 254, in cursor
return self._cursor()
File "/Users/darkbook/anaconda3/lib/python3.6/site-packages/django/db/backends/base/base.py", line 229, in _cursor
self.ensure_connection()
File "/Users/darkbook/anaconda3/lib/python3.6/site-packages/django/db/backends/base/base.py", line 213, in ensure_connection
self.connect()
File "/Users/darkbook/anaconda3/lib/python3.6/site-packages/django/db/utils.py", line 94, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/Users/darkbook/anaconda3/lib/python3.6/site-packages/django/utils/six.py", line 685, in reraise
raise value.with_traceback(tb)
File "/Users/darkbook/anaconda3/lib/python3.6/site-packages/django/db/backends/base/base.py", line 213, in ensure_connection
self.connect()
File "/Users/darkbook/anaconda3/lib/python3.6/site-packages/django/db/backends/base/base.py", line 189, in connect
self.connection = self.get_new_connection(conn_params)
File "/Users/darkbook/anaconda3/lib/python3.6/site-packages/django/db/backends/postgresql/base.py", line 176, in get_new_connection
connection = Database.connect(**conn_params)
File "/Users/darkbook/anaconda3/lib/python3.6/site-packages/psycopg2/__init__.py", line 130, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
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 "/tmp/.s.PGSQL.5432"?回答 2
Stack Overflow用户
回答已采纳
发布于 2018-03-02 14:10:27
如果您没有运行任何PostgreSQL服务器，那么错误消息中的建议“服务器在本地运行吗？”是很有帮助的！)
因为您在OS上，所以我推荐https://postgresapp.com作为开始使用PostgreSQL的最简单的方法。
请注意，尽管在两个地方使用相同的设置都有很好的理由，但是可以在本地使用SQLite开发项目，并在Heroku上使用PostgreSQL。
Stack Overflow用户
发布于 2018-03-09 17:00:39
在连接到Postgres之前，您需要创建Postgres数据库，最简单的方法是使用Postico：https://eggerapps.at/postico/
在Postico中创建数据库(例如db名称"mysite")，然后在您的base.py设置中有如下内容：
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.postgresql_psycopg2',
'NAME': 'mysite',
'USER': '', # e.g 'postgres'
'PASSWORD': '',
'HOST': '', # Set to empty string for localhost.
'PORT': '', # Set to empty string for default.
'CONN_MAX_AGE': 600, # number of seconds database connections should persist for
}}
不要忘记，您需要再次运行迁移来构建所有的表。因此，在manage.py中，您可以运行makemigrations，然后运行migrate。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/49069141
复制相关文章
相似问题
腾讯云开发者
