Fw: Re: Re: Could Not Connect To Server

From: "Dummy Account" <dummyaccount4u(at)mail(dot)com>
To: david(dot)g(dot)johnston(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org, adrian(dot)klaver(at)aklaver(dot)com
Subject: Fw: Re: Re: Could Not Connect To Server
Date: 2020-04-23 22:46:06
Message-ID: trinity-495be6d4-506d-4787-b389-ebcf1bdea073-1587681966539@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 cd&#39;d into log and listed the files. &nbsp;There are many.</div>

<div>How should I get the log that you want.</div>

<div>&nbsp;</div>

<div>&nbsp;</div>

<div>I tried:</div>

<div>
<p>open -a TextEdit postgresql-2020-04-22_171300.log</p>

<p>I got:</p>

<p>LSOpenURLsWithRole() failed for the application /Applications/TextEdit.app with error -610 for the file /Library/PostgreSQL/12/data/log/postgresql-2020-04-22_171300.log.</p>
</div>

<div>&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 5:19 PM<br/>
<b>From:</b>&nbsp;&quot;Dummy Account&quot; &lt;dummyaccount4u(at)mail(dot)com&gt;<br/>
<b>To:</b>&nbsp;&quot;Adrian Klaver&quot; &lt;adrian(dot)klaver(at)aklaver(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">
<div style="font-family: Verdana;font-size: 12.0px;">
<div>This worked.</div>

<div>
<div>sudo su - postgres</div>

<div>I was now able to log into data and ls</div>

<div>Inside data is &quot;log&quot;.</div>

<div>&nbsp;</div>

<div>How do I open log?</div>

<div>and got:</div>

<div>LSOpenURLsWithRole() failed with erro -610</div>

<div>
<div>&nbsp;</div>

<div>I then tried:</div>

<div>log show</div>

<div>and I got:</div>

<div>log: Could not be open local log store: The log archive format is corrupt and cannot be read</div>

<div>&nbsp;</div>

<div>So that right there sounds more conducive to&nbsp;the OS being restored( not that I know&nbsp;), all the files were likely rewritten?</div>

<div>&nbsp;</div>

<div>&nbsp;</div>

<div style="margin: 10.0px 5.0px 5.0px 10.0px;padding: 10.0px 0 10.0px 10.0px;border-left: 2.0px solid rgb(195,217,229);">
<div style="margin: 0 0 10.0px 0;"><b>Sent:</b>&nbsp;Thursday, April 23, 2020 at 5:05 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>On 4/23/20 3:03 PM, Dummy Account wrote:<br/>
&gt; I cannot login into a postgres role via command line.<br/>
&gt; Issue #1.<br/>
&gt; I have never done it before via command line, so maybe I am doing it<br/>
&gt; incorrectly.<br/>
&gt; I have been attempting to go:<br/>
&gt; su - postgres<br/>
&gt; Then it prompts me for the password.<br/>
&gt; Unfortunately, none of the passwords that I think would pertain to<br/>
&gt; Postgres or PgAdmin work.<br/>
&gt; What does work, is the &quot;master password&quot; that I use to log into the<br/>
&gt; pgAdmin Graphical User Interface.<br/>
&gt; I would think that one would work, but it does not.<br/>
<br/>
What did you use to do?:<br/>
<br/>
sudo -u postgres ./pg_ctl start -D /Library/PostgreSQL/12/data<br/>
<br/>
<br/>
&gt; Issue #2.<br/>
&gt; I am thinking out loud hear, there are 3 passwords:<br/>
&gt; Operating System Admin Password: I know that.<br/>
&gt; pgAmin password: I know that.<br/>
&gt; PostgreSQL 12 - the server with multiple database on it. &nbsp;I believe I<br/>
&gt; know that?<br/>
&gt; The issue with that is, while it was not letting me connect, I selected<br/>
&gt; what I think was called &quot;clear password&quot;.<br/>
&gt; Nonetheless, I still have what pgAdmin calls the &quot;master password&quot;.<br/>
&gt; So even if I did remove the password for &quot;PostgreSQL&quot; server, would I be<br/>
&gt; able to reset one?<br/>
&gt; *Sent:*&nbsp;Thursday, April 23, 2020 at 4:26 PM<br/>
&gt; *From:*&nbsp;&quot;Adrian Klaver&quot; &lt;adrian(dot)klaver(at)aklaver(dot)com&gt;<br/>
&gt; *To:*&nbsp;&quot;Dummy Account&quot; &lt;dummyaccount4u(at)mail(dot)com&gt;<br/>
&gt; *Cc:*&nbsp;&quot;pgsql-general&quot; &lt;pgsql-general(at)postgresql(dot)org&gt;, &quot;David G.<br/>
&gt; Johnston&quot; &lt;david(dot)g(dot)johnston(at)gmail(dot)com&gt;<br/>
&gt; *Subject:*&nbsp;Re: Fw: Re: Could Not Connect To Server<br/>
&gt; On 4/23/20 1:37 PM, Dummy Account wrote:<br/>
&gt; &gt; From the Finder, I think that is the same a File Explorer on Widows.<br/>
&gt; &gt; &nbsp;From Finder, it&#39;s locked; I cannot access it. &nbsp;Could I use the command<br/>
&gt; &gt; line and change ownership or access privledges? &nbsp;And then get access?<br/>
&gt;<br/>
&gt; Why not from the command line use a text editor to view the file(s)?<br/>
&gt;<br/>
&gt; &gt; Thanks<br/>
&gt;<br/>
&gt;<br/>
&gt;<br/>
&gt; --<br/>
&gt; Adrian Klaver<br/>
&gt; adrian(dot)klaver(at)aklaver(dot)com<br/>
<br/>
<br/>
--<br/>
Adrian Klaver<br/>
adrian(dot)klaver(at)aklaver(dot)com</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div></div></body></html>

Attachment Content-Type Size
unknown_filename text/html 5.1 KB

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2020-04-23 22:55:42 Re: Fw: Re: Re: Could Not Connect To Server
Previous Message Si Chen 2020-04-23 22:36:55 Re: Ned to understand why all the idle connections