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
