Re: No prompt for setting up a master password

From: richard coleman <rcoleman(dot)ascentgl(at)gmail(dot)com>
To: Stephanie Goulet <stephanie(dot)a(dot)goulet(at)gmail(dot)com>
Cc: Nikhil Mohite <nikhil(dot)mohite(at)enterprisedb(dot)com>, pgadmin-support(at)postgresql(dot)org
Subject: Re: No prompt for setting up a master password
Date: 2023-06-07 22:15:16
Message-ID: CAGA3vBvkXrKc6eAqx1H3ypwXOi54c1rMj7dnN5_y6nZ-wmi4Xw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-general

Stephanie,

That form has nothing to do with a master password. It's the form used to
save connection settings to a cluster.

Host name/address is the DNS name or IP address of the server hosting the
cluster.
Port is the port that PostgreSQL instance is listening on, defaults to 5432.
Maintenance Database is just what it says, the maintenance database in that
cluster, postgres is the default.
Username is the username of the role you want to use to connect to the
cluster.
Password is the password for the role that you specified in username.
Save Password toggle is for if you want pgAdmin to remember the password
for this connection. It's only if you do that the matter of whether or not
you are using a Master Password matters.
Role is if you want to connect as one role but work as an alternate one.

The rest don't usually apply to most people, but may be applicable in
certain situations.

And that error is from the first tab, it's the name of the connection in
pgAdmin and it can't be left blank. I usually use the name of the server
as a basis for that value.

I hope that that helps,
rik.

On Wed, Jun 7, 2023 at 5:36 PM Stephanie Goulet <
stephanie(dot)a(dot)goulet(at)gmail(dot)com> wrote:

> Thanks, Nikhil! That's probably it (I am using version 7.2), but I'm still
> a bit confused.
>
> For example, when registering a server, what would I put in this password
> field (screenshot below) if I don't have a master password?
>
> [image: Screen Shot 2023-06-07 at 5.33.53 PM.png]
>
> ᐧ
>
> On Wed, Jun 7, 2023 at 12:48 AM Nikhil Mohite <
> nikhil(dot)mohite(at)enterprisedb(dot)com> wrote:
>
>> Hi Stephanie,
>>
>> Can you please provide the pgAdmin 4 version details?
>>
>> If you are using pgAdmin 4 version 7.2 onwards it uses the operating
>> system's secret storage to store the passwords in desktop mode.
>> please refer:
>> https://www.pgadmin.org/docs/pgadmin4/latest/master_password.html
>> <https://www.pgadmin.org/docs/pgadmin4/7.3/master_password.html>
>>
>> On Tue, Jun 6, 2023 at 11:06 PM Stephanie Goulet <
>> stephanie(dot)a(dot)goulet(at)gmail(dot)com> wrote:
>>
>>> Hi all,
>>>
>>> Hope you're well. I'm a new user and was trying to set pgAdmin up for
>>> the first time. All of the instructions and tutorials and other resources I
>>> can find outline how there should be a prompt for setting up a master
>>> password when you first open. This did not appear for me. I tried deleting,
>>> redownloading, and opening again and it still doesn't appear. When opening
>>> the program after download, it also doesn't ask for a password (only when
>>> trying to connect to a server). If it's helpful to know, I'm using Mac OS.
>>>
>>> Is there a way to set the master password without having the prompt
>>> appear? If yes, where/how? If not, what might you recommend for this
>>> situation?
>>>
>>> Thank you in advance.
>>>
>>> Stephanie
>>>
>>>
>> Regards,
>> Nikhil Mohite
>>
>>> ᐧ
>>>
>>

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Gerd Wilmer 2023-06-18 02:14:43 pgAdmin on Big sur
Previous Message Stephanie Goulet 2023-06-07 21:35:38 Re: No prompt for setting up a master password

Browse pgsql-general by date

  From Date Subject
Next Message Amit Kapila 2023-06-08 05:05:54 Re: Support logical replication of DDLs
Previous Message Stephanie Goulet 2023-06-07 21:35:38 Re: No prompt for setting up a master password