How to behive if I remove password from postgres role

From: Raivo Rebane <raivore55(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: How to behive if I remove password from postgres role
Date: 2023-03-15 16:02:09
Message-ID: CAMH5fptfyfH=WpvLg+aX1XacDJEe8Tpz7gk+LGhJSp7kVVT7eA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

HI

I wanted to install PostGIS Bundle so that it builds a sample spatial
database, but got error - createdb: error: connection to server at
"localhost" (::1), port 5432 failed: FATAL: password authentication failed
for user "postgres"
Then I altered role of postgres so, that password = NULL.
Now I am in situation that I can't run any postgres command.
What I must to do ?

Regards,
Raivo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2023-03-15 16:03:22 Re: Table scan on 15.2
Previous Message Arthur Ramsey 2023-03-15 15:53:06 Re: Table scan on 15.2