| 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> </div>
<div>
<div>I cd'd into log and listed the files. There are many.</div>
<div>How should I get the log that you want.</div>
<div> </div>
<div> </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> </div>
<div>
<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> Thursday, April 23, 2020 at 5:19 PM<br/>
<b>From:</b> "Dummy Account" <dummyaccount4u(at)mail(dot)com><br/>
<b>To:</b> "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com><br/>
<b>Cc:</b> "pgsql-general" <pgsql-general(at)postgresql(dot)org>, "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com><br/>
<b>Subject:</b> 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 "log".</div>
<div> </div>
<div>How do I open log?</div>
<div>and got:</div>
<div>LSOpenURLsWithRole() failed with erro -610</div>
<div>
<div> </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> </div>
<div>So that right there sounds more conducive to the OS being restored( not that I know ), all the files were likely rewritten?</div>
<div> </div>
<div> </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> Thursday, April 23, 2020 at 5:05 PM<br/>
<b>From:</b> "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com><br/>
<b>To:</b> "Dummy Account" <dummyaccount4u(at)mail(dot)com><br/>
<b>Cc:</b> "pgsql-general" <pgsql-general(at)postgresql(dot)org>, "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com><br/>
<b>Subject:</b> Re: Fw: Re: Could Not Connect To Server</div>
<div>On 4/23/20 3:03 PM, Dummy Account wrote:<br/>
> I cannot login into a postgres role via command line.<br/>
> Issue #1.<br/>
> I have never done it before via command line, so maybe I am doing it<br/>
> incorrectly.<br/>
> I have been attempting to go:<br/>
> su - postgres<br/>
> Then it prompts me for the password.<br/>
> Unfortunately, none of the passwords that I think would pertain to<br/>
> Postgres or PgAdmin work.<br/>
> What does work, is the "master password" that I use to log into the<br/>
> pgAdmin Graphical User Interface.<br/>
> 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/>
> Issue #2.<br/>
> I am thinking out loud hear, there are 3 passwords:<br/>
> Operating System Admin Password: I know that.<br/>
> pgAmin password: I know that.<br/>
> PostgreSQL 12 - the server with multiple database on it. I believe I<br/>
> know that?<br/>
> The issue with that is, while it was not letting me connect, I selected<br/>
> what I think was called "clear password".<br/>
> Nonetheless, I still have what pgAdmin calls the "master password".<br/>
> So even if I did remove the password for "PostgreSQL" server, would I be<br/>
> able to reset one?<br/>
> *Sent:* Thursday, April 23, 2020 at 4:26 PM<br/>
> *From:* "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com><br/>
> *To:* "Dummy Account" <dummyaccount4u(at)mail(dot)com><br/>
> *Cc:* "pgsql-general" <pgsql-general(at)postgresql(dot)org>, "David G.<br/>
> Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com><br/>
> *Subject:* Re: Fw: Re: Could Not Connect To Server<br/>
> On 4/23/20 1:37 PM, Dummy Account wrote:<br/>
> > From the Finder, I think that is the same a File Explorer on Widows.<br/>
> > From Finder, it's locked; I cannot access it. Could I use the command<br/>
> > line and change ownership or access privledges? And then get access?<br/>
><br/>
> Why not from the command line use a text editor to view the file(s)?<br/>
><br/>
> > Thanks<br/>
><br/>
><br/>
><br/>
> --<br/>
> Adrian Klaver<br/>
> 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 |
| 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 |