Home / ubuntu / Questions / 1150778
In Process
Thomas Landauer
Asked: 2019-06-14 04:05:02 +0800 CST

pgAdmin4 disable master password

  • 772

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

pgadmin

2 Answers

  1. 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/

    • 26

  2. 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

    • 9