Re: Fw: Re: Could Not Connect To Server

From: "Dummy Account" <dummyaccount4u(at)mail(dot)com>
To: "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Subject: Re: Fw: Re: Could Not Connect To Server
Date: 2020-04-23 22:03:22
Message-ID: trinity-8485523e-16c0-4282-82a6-5364b7b11433-1587679402313@3c-app-mailcom-lxa16
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>&nbsp;</div>

<div>
<div>I cannot login into a postgres role via command line. &nbsp;</div>

<div>&nbsp;</div>

<div>Issue #1.</div>

<div>I have never done it before via command line, so maybe I am doing it incorrectly.</div>

<div>I have been attempting to go:&nbsp;</div>

<div>&nbsp;</div>

<div>su - postgres</div>

<div>&nbsp;</div>

<div>Then it prompts me for the password.</div>

<div>Unfortunately, none of the passwords that I think would pertain to Postgres or PgAdmin work. &nbsp;</div>

<div>What does work, is the &quot;master password&quot; that I use to log into the pgAdmin Graphical User Interface.</div>

<div>I would think that one would work, but it does not.</div>

<div>&nbsp;</div>

<div>Issue #2.</div>

<div>I am thinking out loud hear, there are 3 passwords:</div>

<div>Operating System Admin Password: I know that.</div>

<div>pgAmin password: I know that.</div>

<div>PostgreSQL 12 - the server with multiple database on it. &nbsp;I believe I know that?</div>

<div>The issue with that is, while it was not letting me connect, I selected what I think was called &quot;clear password&quot;.</div>

<div>Nonetheless, I still have what pgAdmin calls the &quot;master password&quot;.</div>

<div>So even if I did remove the password for &quot;PostgreSQL&quot; server, would I be able to reset one?&nbsp;</div>

<div>&nbsp;
<div name="quote" style="margin:10px 5px 5px 10px; padding: 10px 0 10px 10px; border-left:2px solid #C3D9E5; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">
<div style="margin:0 0 10px 0;"><b>Sent:</b>&nbsp;Thursday, April 23, 2020 at 4:26 PM<br/>
<b>From:</b>&nbsp;&quot;Adrian Klaver&quot; &lt;adrian(dot)klaver(at)aklaver(dot)com&gt;<br/>
<b>To:</b>&nbsp;&quot;Dummy Account&quot; &lt;dummyaccount4u(at)mail(dot)com&gt;<br/>
<b>Cc:</b>&nbsp;&quot;pgsql-general&quot; &lt;pgsql-general(at)postgresql(dot)org&gt;, &quot;David G. Johnston&quot; &lt;david(dot)g(dot)johnston(at)gmail(dot)com&gt;<br/>
<b>Subject:</b>&nbsp;Re: Fw: Re: Could Not Connect To Server</div>

<div name="quoted-content">On 4/23/20 1:37 PM, Dummy Account wrote:<br/>
&gt; From the Finder, I think that is the same a File Explorer on Widows.<br/>
&gt; &nbsp;From Finder, it&#39;s locked; I cannot access it. &nbsp;Could I use the command<br/>
&gt; line and change ownership or access privledges? &nbsp;And then get access?<br/>
<br/>
Why not from the command line use a text editor to view the file(s)?<br/>
<br/>
&gt; Thanks<br/>
<br/>
<br/>
<br/>
--<br/>
Adrian Klaver<br/>
adrian(dot)klaver(at)aklaver(dot)com</div>
</div>
</div>
</div></div></body></html>

Attachment Content-Type Size
unknown_filename text/html 2.6 KB

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-04-23 22:05:36 Re: Fw: Re: Could Not Connect To Server
Previous Message Justin King 2020-04-23 21:40:33 Re: walreceiver termination