Re: Fw: Re: Could Not Connect To Server

["Dummy Account" <dummyaccount4u@xxxxxxxx>]

 

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.

 

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