centos7下yum安装postgre数据库之后，数据库连接的配置位于/var/lib/pgsql/data/pg_hba.conf中。
执行数据库迁移时报错信息如下。[root@localhost codeoncloud]# python manage.py migrateTraceback (most recent call last): File "manage.py", line 10, in <module>execute_from_command_line(sys.argv) File "/usr/lib/python2.7/site-packages/django/core/management/__init__.py", line 338, in execute_from_command_lineutility.execute() File "/usr/lib/python2.7/site-packages/django/core/management/__init__.py", line 330, in executeself.fetch_command(subcommand).run_from_argv(self.argv) File "/usr/lib/python2.7/site-packages/django/core/management/base.py", line 390, in run_from_argvself.execute(*args, **cmd_options) File "/usr/lib/python2.7/site-packages/django/core/management/base.py", line 441, in executeoutput = self.handle(*args, **options) File "/usr/lib/python2.7/site-packages/django/core/management/commands/migrate.py", line 93, in handleexecutor = MigrationExecutor(connection, self.migration_progress_callback) File "/usr/lib/python2.7/site-packages/django/db/migrations/executor.py", line 19, in __init__self.loader = MigrationLoader(self.connection) File "/usr/lib/python2.7/site-packages/django/db/migrations/loader.py", line 47, in __init__self.build_graph() File "/usr/lib/python2.7/site-packages/django/db/migrations/loader.py", line 180, in build_graphself.applied_migrations = recorder.applied_migrations() File "/usr/lib/python2.7/site-packages/django/db/migrations/recorder.py", line 59, in applied_migrationsself.ensure_schema() File "/usr/lib/python2.7/site-packages/django/db/migrations/recorder.py", line 49, in ensure_schemaif self.Migration._meta.db_table in self.connection.introspection.table_names(self.connection.cursor()): File "/usr/lib/python2.7/site-packages/django/db/backends/base/base.py", line 162, in cursorcursor = self.make_debug_cursor(self._cursor()) File "/usr/lib/python2.7/site-packages/django/db/backends/base/base.py", line 135, in _cursorself.ensure_connection() File "/usr/lib/python2.7/site-packages/django/db/backends/base/base.py", line 130, in ensure_connectionself.connect() File "/usr/lib/python2.7/site-packages/django/db/utils.py", line 97, in __exit__six.reraise(dj_exc_type, dj_exc_value, traceback) File "/usr/lib/python2.7/site-packages/django/db/backends/base/base.py", line 130, in ensure_connectionself.connect() File "/usr/lib/python2.7/site-packages/django/db/backends/base/base.py", line 119, in connectself.connection = self.get_new_connection(conn_params) File "/usr/lib/python2.7/site-packages/django/db/backends/postgresql_psycopg2/base.py", line 176, in get_new_connectionconnection = Database.connect(**conn_params) File "/usr/lib64/python2.7/site-packages/psycopg2/__init__.py", line 164, in connectconn = _connect(dsn, connection_factory=connection_factory, async=async)django.db.utils.OperationalError: FATAL: Peer authentication failed for user "postgres"
将/var/lib/pgsql/data/pg_hba.conf中第80行改为如下
79 # "local" is for Unix domain socket connections only 80 local allalltrust
版权声明：本文为博主原创文章，未经博主允许不得转载。
，一个人负心，或许是因为他的记忆力不好。
