HINT: 'postgresql.protocol' only supports: MD5, crypt, plaintext, and trust. : unsupported authentication request ''(10) The above exception was the direct cause of the following exception:

Self.socket = self.socket_factory(timeout = timeout)įile '/Users/steven/Documents/customers/Green/BQ/.venv/lib/python3.9/site-packages/postgresql/python/socket.py', line 65, in _call_ĬonnectionRefusedError: Connection refused : could not establish connection to serverįile '/Users/steven/Documents/customers/Green/BQ/.venv/lib/python3.9/site-packages/postgresql/protocol/client3.py', line 136, in connect _client_error(could_not_connect, creator = self, cause = exc)įile '/Users/steven/Documents/customers/Green/BQ/.venv/lib/python3.9/site-packages/postgresql/driver/pq3.py', line 514, in raise_client_error Return _run_code(code, main_globals, None,įile '/Users/steven/.pyenv/versions/3.9.0/lib/python3.9/runpy.py', line 87, in _run_codeįile '/Users/steven/Documents/customers/Green/BQ/.venv/lib/python3.9/site-packages/postgresql/bin/pg_python.py', line 136, in įile '/Users/steven/Documents/customers/Green/BQ/.venv/lib/python3.9/site-packages/postgresql/bin/pg_python.py', line 75, in commandįile '/Users/steven/Documents/customers/Green/BQ/.venv/lib/python3.9/site-packages/postgresql/driver/pq3.py', line 2427, in connectįile '/Users/steven/Documents/customers/Green/BQ/.venv/lib/python3.9/site-packages/postgresql/driver/pq3.py', line 2553, in _establish > 717 cursor.execute(statement, parameters)ħ19 def do_execute_no_params(self, cursor, statement, context=None): ~/anaconda3/lib/python3.8/site-packages/sqlalchemy/engine/default.py in do_execute(self, cursor, statement, parameters, context)ħ16 def do_execute(self, cursor, statement, parameters, context=None): ~/anaconda3/lib/python3.8/site-packages/sqlalchemy/util/compat.py in raise_(***failed resolving arguments***)ġ772 cursor, statement, parameters, context > 1999 util.raise_(exc_info, with_traceback=exc_info) ~/anaconda3/lib/python3.8/site-packages/sqlalchemy/engine/base.py in _handle_dbapi_exception(self, e, statement, parameters, cursor, context)

~/anaconda3/lib/python3.8/site-packages/sqlalchemy/engine/base.py in _execute_context(self, dialect, constructor, statement, parameters, execution_options, *args, **kw)ġ815 e, statement, parameters, cursor, context ~/anaconda3/lib/python3.8/site-packages/sqlalchemy/engine/base.py in _exec_driver_sql(self, statement, multiparams, params, execution_options, future)ġ549 dialect.execution_ctx_cls._init_statement, ~/anaconda3/lib/python3.8/site-packages/sqlalchemy/engine/base.py in execute(self, statement, *multiparams, **params) > 1424 return _options().execute(*args, **kwargs) ~/anaconda3/lib/python3.8/site-packages/pandas/io/sql.py in execute(self, *args, **kwargs)ġ423 '''Simple passthrough to SQLAlchemy connectable''' ~/anaconda3/lib/python3.8/site-packages/pandas/io/sql.py in read_query(self, sql, index_col, coerce_float, parse_dates, params, chunksize, dtype) ~/anaconda3/lib/python3.8/site-packages/pandas/io/sql.py in read_sql_query(sql, con, index_col, coerce_float, params, parse_dates, chunksize, dtype) > 8 df = pd.read_sql_query(query, connection) KeyError Traceback (most recent call last) Is the server running on host 'localhost' (127.0.0.1) and accepting Is the server running on host 'localhost' (::1) and acceptingĬould not connect to server: Connection refused Psql: error: could not connect to server: Connection refused ✖2 ❯ psql -h localhost -p 6432 -U root -d db_my_test_app Psql: error: FATAL: database 'root' does not exist

Postico connect to docker database