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

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com