查看“Django 配置postgresql数据库”的源代码

在django中使用postgresql数据库

You need to install psycopg2 Python library.

==Installation==
<pre>
Download http://initd.org/psycopg/, then install it under Python PATH
After downloading, easily extract the tarball and:
$ python setup.py install
Or if you wish, install it by either easy_install or pip.

(I prefer to use pip over easy_install for no reason.)
$ easy_install psycopg2
$ pip install psycopg2 </pre>


== Configuration==

=== postgresql  Configuration===
<pre>
su - postgres
psql 

postgres=# create  database mydatabase TEMPLATE = template0   ENCODING = 'UTF8' ;

sudo vim /etc/postgresql/9.6/main/pg_hba.conf

host    all     all         127.0.0.1/32                         trust 
</pre>
=== django Configuration===
<pre>
in settings.py

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'db_name',                      
        'USER': 'db_user',
        'PASSWORD': 'db_user_password',
        'HOST': '',
        'PORT': 'db_port_number',
    }
}

#my setttings file
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': 'mydatabase',
        'USER': 'postgres',
        'PASSWORD': '2233333',
        'HOST': '127.0.0.1',
        'PORT': '5432',
    }
}
<pre>
==mysql etc ==
mysqlclient是MySQLdb的一个分支，它与python3有着特别好的契合并且可以作为MySQLdb的直接替代。在书写这篇的时候，这是在Django使用MySQL的推荐的选择。
MySQL Connector/Python是一个来自Oracle的纯python驱动，它不需要MySQL client库或在标准库之外的任何Python模块。
所有这些驱动都是线程安全的，并提供连接池。MySQLdb是当前唯一一个不支持python3的




=参考=

[[Django 配置MySQL数据库]]

[https://stackoverflow.com/questions/5394331/how-to-setup-postgresql-database-in-django How to setup PostgreSQL Database in Django]

https://docs.djangoproject.com/en/1.8/ref/settings/#databases

http://usyiyi.cn/documents/django_182/ref/databases.html#postgresql-notes

[https://www.digitalocean.com/community/tutorials/how-to-install-and-configure-django-with-postgres-nginx-and-gunicorn How To Install and Configure Django with Postgres, Nginx, and Gunicorn]


[[category:djanog]]