E
E
Elvinchik2022-02-06 09:12:59
PostgreSQL
Elvinchik, 2022-02-06 09:12:59

Can't connect to PostgreSQL remotely?

Traceback (most recent call last):
  File "c:\Users\Admin\Desktop\programming\ShadowBot\main.py", line 10, in <module>
    import sql
  File "c:\Users\Admin\Desktop\programming\ShadowBot\sql.py", line 5, in <module>
    connect = psycopg2.connect(
  File "C:\Users\Admin\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.9_qbz5n2kfra8p0\LocalCache\local-packages\Python39\site-packages\psycopg2\__init__.py", line 122, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: connection to server at "postgres.hostman.site" (94.228.113.90), port 5434 failed: FATAL:  password authentication failed for user "hostman"


host = "postgres.hostman.site"
user = "hostman"
port = 5434
password = "password"
database = "database"


What is the problem?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
H
Hanneman, 2022-02-06
@Hanneman

password authentication failed for user "hostman" says nothing?
Either the password is incorrect or the user does not have connection privileges from another (remote) host - this must be configured for that particular user. I will not rewrite, see the manual .

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question