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 <k...@karlpinc.com> wrote: > > On Tue, 24 Oct 2023 13:41:17 -0700 > Tim Quinn <timquin...@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 <k...@karlpinc.com> > Free Software: "You don't pay back, you pay forward." > -- Robert A. Heinlein
