postgres 12 password failure port 5433

Zahid Rahman <[email protected]> Sun, 15 Dec 2019 15:18:37 +0000
Newsgroups gmane.comp.db.postgresql.novice
Message-ID <CAPGSW3RjsNhwWORmqj=eXo1CHWyhZ0-nFcKXS+2K8WdNJmvWyg@mail.gmail.com>
--0000000000009092930599bf9cd1
Content-Type: text/plain; charset="UTF-8"

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

--0000000000009092930599bf9cd1
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div>Hi,</div><div>I have postgres 10 run=
ning on 5432 and pgadmin is connecting=C2=A0 ok.</div><div><br></div><div>=
=C2=A0I have just installed postgres 12 on ubuntu 18.04=C2=A0 using apt-get=
 install<br></div><div>I have the following=C2=A0 success messages (see bel=
ow)</div><div>I have verified that I have a database running at 5433 progra=
mmatically.</div><div>The PGADMIN4 &quot;postgres admin tool&quot; is givin=
g an error &quot;UNAUTHORISED message (see below)<br></div><div><h1><span s=
tyle=3D"font-weight:normal"><font size=3D"2">WHEN i TRY TO LOGIN USING=C2=
=A0 PSQL CONSOLE using command line <br></font></span></h1><h1><span style=
=3D"font-weight:normal"><font size=3D"2">psql -U postgres =C2=A0-p 5433 -h =
localhost</font></span></h1><h1><span style=3D"font-weight:normal"><font si=
ze=3D"2">I get an password=C2=A0 error message</font></span><font size=3D"1=
"> psql: error: could not connect to server: FATAL: =C2=A0password authenti=
cation failed for user &quot;postgres&quot;</font><br></h1><div>FATAL: =C2=
=A0password authentication failed for user &quot;postgres&quot;<br></div><d=
iv><br></div><h1>Unauthorized</h1>
<p>The server could not verify that you are authorized to access the URL
 requested.  You either supplied the wrong credentials (e.g. a bad=20
password), or your browser doesn&#39;t understand how to supply the=20
credentials required.</p></div><div> <br></div><div><br></div><div><br></di=
v><div> <br></div><div><br></div><div><br></div><div>Success. You can now s=
tart the database server using: <br>pg_ctlcluster 12 main start<br><br>Ver =
Cluster Port Status Owner =C2=A0 =C2=A0Data directory =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0Log file<br>12 =C2=A0main =C2=A0 =C2=A05433 down=
 =C2=A0 postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql=
-12-main.log</div><div><br></div><div><br></div><div><br></div><div> <br></=
div><div><br></div><div><br></div></div></div>

--0000000000009092930599bf9cd1--