One small note. Aside from the fact that your server is running from a different port, psycopg2 does not support authentication without password afaik. It has bit me twice
On Sun, Jan 24, 2021 at 12:34 PM Julien Rouhaud <rjuju123@xxxxxxxxx> wrote:
On Sun, Jan 24, 2021 at 2:58 PM robert@xxxxxxxxxx <robert@xxxxxxxxxx> wrote:
>
> root@elfero-test:~/scripts# pg_lsclusters
> Ver Cluster Port Status Owner Data directory Log file
> 10 main 5433 online postgres /var/lib/postgresql/10/main /var/log/postgresql/postgresql-10-main.log
> [...]
> 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?
It looks like your instance is configured to listen on port 5433, not 5432.
