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 "postgres admin tool" is givin= g an error "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 "postgres"</font><br></h1><div>FATAL: =C2= =A0password authentication failed for user "postgres"<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'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--