postgres 12 password failure port 5433

From: Zahid Rahman <zahidr1000(at)gmail(dot)com>
To: pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: postgres 12 password failure port 5433
Date: 2019-12-15 15:18:37
Message-ID: CAPGSW3RjsNhwWORmqj=eXo1CHWyhZ0-nFcKXS+2K8WdNJmvWyg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,
I have postgres 10 running on 5432 and pgadmin is connecting ok.

I have just installed postgres 12 on ubuntu 18.04 using apt-get install
I have the following success messages (see below)
I have verified that I have a database running at 5433 programmatically.
The PGADMIN4 "postgres admin tool" is giving an error "UNAUTHORISED message
(see below)
WHEN i TRY TO LOGIN USING PSQL CONSOLE using command line
psql -U postgres -p 5433 -h localhostI get an password error message
psql: error: could not connect to server: FATAL: password authentication
failed for user "postgres"
FATAL: password authentication failed for user "postgres"

Unauthorized

The server could not verify that you are authorized to access the URL
requested. You either supplied the wrong credentials (e.g. a bad password),
or your browser doesn't understand how to supply the credentials required.

Success. You can now start the database server using:
pg_ctlcluster 12 main start

Ver Cluster Port Status Owner Data directory Log file
12 main 5433 down postgres /var/lib/postgresql/12/main
/var/log/postgresql/postgresql-12-main.log

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Zahid Rahman 2019-12-15 16:10:08 Re: postgres 12 password failure port 5433
Previous Message Zahid Rahman 2019-12-15 14:37:32 Hi : Is anybody out there ?