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 <rjuju...@gmail.com> wrote: > On Sun, Jan 24, 2021 at 2:58 PM rob...@redo2oo.ch <rob...@redo2oo.ch> > 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. > > >
