Re: Never asked to set Master Password

On Tue, 24 Oct 2023 13:41:17 -0700
Tim Quinn <timquinnsm@gmail.com> wrote:

> Hi Karl,
> 
> I do not see my email anywhere on pgAdmin4? There is nothing in the
> upper right hand corner to click on.
> 
> So maybe I am not logged in. How can I log in or create an account?

I am not very experienced with pgAdmin4.

It may be that you're running a desktop install?
I don't know how to tell it what pg username goes with
what pg database.

In any case, the connection string in your screenshot indicates
that you are going to login to PG as the "postgres" user.  As a rule,
the postgres user cannot be logged into unless you are logged in
to Unix as the postgres user.  (It is unlikely you want to change
this.  Better to have your own personal login, and be able to
"SET ROLE postgres" when you want to be the superuser.)

If you don't have a PG login, maybe the best way to create
one is with psql.

sudo su postgres -c psql

Then:

create role MYLOGIN createdb login noinherit in role postgres;
\password MYLOGIN
\q

(Alternately, "\password", by itself, changes the current
user's password.  You could use that to set a password for
the postgres user.  This only makes sense if you're going
to be the only one who knows the password.  Sharing superuser
passwords is ungood.)

You seem to have multiple PG versions installed.  It is hard
to say which one the above will create a login in.  The
screenshot seems to indicate it will be the v14 cluster.

Hope this helps.

Regards,

Karl <kop@karlpinc.com>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein