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