Python: Connecting to Postgres DB via SSH?

Question

Python

Hello.
Interested in connecting to the Postgres database using Python.
First you need to create an ssh tunnel.
If there is a live example - generally great.
I myself am trying to solve the problem this way: I use the sshtunnel + psycopg2 libraries.
I also tried other libraries for working with Postgres and Python - for example, PygreSql, pg8000 and spur.
Using ssh (from the command line), the tunnel is built, I connect to the database. I also easily connect to the database through software (Beaver).
As a result, I still ran into an error:
password authentication failed for user "vanja-ivanov"
PS I do everything described under Linux (Ubuntu). If there is a solution for Windows, I will also not refuse.