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@aklaver.com>
> *To:* "Dummy Account" <dummyaccount4u@mail.com>
> *Cc:* "pgsql-general" <pgsql-general@postgresql.org>, "David G. 
> Johnston" <david.g.johnston@gmail.com>
> *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@aklaver.com


-- 
Adrian Klaver
adrian.klaver@aklaver.com