| 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:19:49 |
| Message-ID: | trinity-7f6cceb7-2f84-4af3-a364-365f0a33d930-1587680389261@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>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 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: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 name="quoted-content">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></body></html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 3.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Sargent | 2020-04-23 22:22:58 | Re: Fw: Re: Could Not Connect To Server |
| Previous Message | David G. Johnston | 2020-04-23 22:06:14 | Re: Fw: Re: Could Not Connect To Server |