24

When starting pgAdmin, I'm prompted:

Please set a master password for pgAdmin

This is a new feature of pgAdmin4 4.7: https://www.pgadmin.org/docs/pgadmin4/dev/release_notes_4_7.html

How can I disable this?

The local documentation tells me to set the "configuration parameter" MASTER_PASSWORD_REQUIRED=False, but I don't know where/how to do this: http://127.0.0.1:37059/help/help/master_password.html

Thomas Landauer
  • 831
  • 2
  • 8
  • 18

2 Answers2

30

Took me a while to find out, that's why I'm posting it here:

  1. You need to locate a file named config.py. In my case it's at /usr/share/pgadmin4/web/config.py
  2. Now create a file config_local.py (in the same folder) and enter: MASTER_PASSWORD_REQUIRED=False
  3. Restart pgAdmin server.
  4. The prompt should be gone :-)

Some reference about config files: https://www.pgadmin.org/docs/pgadmin4/dev/desktop_deployment.html#configuration

EDIT: It looks like in higher versions (I now have pgAdmin4 4.26) the directory changed to /usr/pgadmin4/web/

Thomas Landauer
  • 831
  • 2
  • 8
  • 18
11

For those on windows, the config.py is located under

C:\Program Files\PostgreSQL\12\pgAdmin 4\web

or

C:\Program Files (x86)\pgAdmin 4\v4\web

Create config_local.py inside of that folder

yujinyuz
  • 111