Re: Never asked to set Master Password

Hi Karl,

Yes, it appears to be a desktop install on my mac.

I am not sure what Unix is?

I will be the only one using this. I don’t have a PG login.
How do I create one with pqsl? Where would I input those codes?

I am trying to use PostgreSQL 14 on a mac. I installed earlier versions to see if that was why I am getting stuck at the password but all of them asked the same thing.

Again, I apologize since I am learning through a Udemy class and I am starting from scratch trying to understand how to get started.

Thank you,
-Tim Q

> On Oct 24, 2023, at 2:15 PM, Karl O. Pinc <kop(at)karlpinc(dot)com> wrote:
>
> On Tue, 24 Oct 2023 13:41:17 -0700
> Tim Quinn <timquinnsm(at)gmail(dot)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(at)karlpinc(dot)com>
> Free Software: "You don't pay back, you pay forward."
> -- Robert A. Heinlein