Re: ubuntu 18: PostgreSQL does not start. how can I totally remove and reinstall it - Mailing list pgsql-general

From Hemil Ruparel
Subject Re: ubuntu 18: PostgreSQL does not start. how can I totally remove and reinstall it
Date
Msg-id CANW1aT9WkW=D0p0Uy9PMOvtYkz01JNDOPHGKZsNQ1n3YGFijvA@mail.gmail.com
Whole thread Raw
In response to Re: ubuntu 18: PostgreSQL does not start. how can I totally remove and reinstall it  (Julien Rouhaud <rjuju123@gmail.com>)
Responses Re: ubuntu 18: PostgreSQL does not start. how can I totally remove and reinstall it
Re: ubuntu 18: PostgreSQL does not start. how can I totally remove and reinstall it
Re: ubuntu 18: PostgreSQL does not start. how can I totally remove and reinstall it
List pgsql-general
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@gmail.com> wrote:
On Sun, Jan 24, 2021 at 2:58 PM robert@redo2oo.ch <robert@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.


pgsql-general by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: ubuntu 18: PostgreSQL does not start. how can I totally remove and reinstall it
Next
From: robert rottermann
Date:
Subject: solved (was plain stupidity) Re: ubuntu 18: PostgreSQL does not start. how can I totally remove and reinstall it