无法连接到postgres数据库

Question

我是新的烧瓶框架，当我尝试连接到终端上的数据库时，我遇到错误，请帮助。在

from flask import Flask, jsonify
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__) #flask app is created here
app.config['SQLALCHEMY_DATABASE_URI'] = 'postgresql://postgres:password@localhost/test'
db = SQLAlchemy(app) 

class Locatn(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    place = db.Column(db.String(20), unique=True)
    location = db.Column(db.String(20), unique=True)

    def __init__(self, place, location):
    self.place = place
    self.location = location

    def __repr__(self):
    return '<Locatn %r>' % self.place

from app import db /home/ifiok/.virtualenvs/favplaces/lib/python3.6/site-packages/flask_sqlalchemy/init.py:794: FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning. 'SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and ' db.create_all() Traceback (most recent call last): File "/home/ifiok/.virtualenvs/favplaces/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2158, in _wrap_pool_connect return fn() File "/home/ifiok/.virtualenvs/favplaces/lib/python3.6/site-packages/sqlalchemy/pool.py", line 403, in connect return _ConnectionFairy._checkout(self) File "/home/ifiok/.virtualenvs/favplaces/lib/python3.6/site-packages/sqlalchemy/pool.py", line 788, in _checkout fairy = _ConnectionRecord.checkout(pool) File "/home/ifiok/.virtualenvs/favplaces/lib/python3.6/site-packages/sqlalchemy/pool.py", line 532, in checkout rec = pool._do_get() File "/home/ifiok/.virtualenvs/favplaces/lib/python3.6/site-packages/sqlalchemy/pool.py", line 1193, in _do_get self._dec_overflow() File "/home/ifiok/.virtualenvs/favplaces/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 66, in exit compat.reraise(exc_type, exc_value, exc_tb) File "/home/ifiok/.virtualenvs/favplaces/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 187, in reraise raise value File "/home/ifiok/.virtualenvs/favplaces/lib/python3.6/site-packages/sqlalchemy/pool.py", line 1190, in _do_get return self._create_connection() File "/home/ifiok/.virtualenvs/favplaces/lib/python3.6/site-packages/sqlalchemy/pool.py", line 350, in _create_connection return _ConnectionRecord(self) File "/home/ifiok/.virtualenvs/favplaces/lib/python3.6/site-packages/sqlalchemy/pool.py", line 477, in init self.connect(first_connect_check=True) File "/home/ifiok/.virtualenvs/favplaces/lib/python3.6/site-packages/sqlalchemy/pool.py", line 671, in __connect connection = pool._invoke_creator(self) File "/home/ifiok/.virtualenvs/favplaces/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 106, in connect return dialect.connect(*cargs, **cparams) File "/home/ifiok/.virtualenvs/favplaces/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 410, in connect return self.dbapi.connect(*cargs, **cparams) File "/home/ifiok/.virtualenvs/favplaces/lib/python3.6/site-packages/psycopg2/__init.py", line 130, in connect conn = _connect(dsn, connection_factory=connection_factory, **kwasync) psycopg2.OperationalError: could not connect to server: Connection refused Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?