Hi, You can use the command 'update-user' for user update.
To explore more options, you can use the command below with pgadmin venv. `python3.12 setup.py update-user --help ` Typical command would be - `python3.12 setup.py update-user <user_id> --password <new_password> --role Administrator --sqlite-path <pgadmin_db_path>` Thanks, Yogesh Mahajan EnterpriseDB On Sat, Jun 14, 2025 at 5:09 PM Shakir Idrisi <sha...@webuzo.com> wrote: > Hi, > > I hope you're doing well. > > pgAdmin is now working properly. Earlier, I ran the setup-db command and > set the admin username and password. > > Now, after reinstalling pgAdmin, I noticed that the data directory > (including pgadmin.db) was not removed. I would like to either reuse the > old admin password or reset it if needed. > > Is there a way to reset the admin user's password using a command in this > case? > Your guidance would be greatly appreciated. > > Thank you for your help. > > On Tue, Jun 10, 2025, 9:57 PM Shakir Idrisi <sha...@webuzo.com> wrote: > >> Ok, I will check. >> >> On Tue, Jun 10, 2025, 5:26 PM Yogesh Mahajan < >> yogesh.maha...@enterprisedb.com> wrote: >> >>> Hi, >>> >>> I could reproduce the error when I have multiple workers. Maybe you can >>> try restarting the Guicorn service. >>> Can you please try once in the private browser window? >>> >>> Thanks, >>> Yogesh Mahajan >>> EnterpriseDB >>> >>> >>> On Tue, Jun 10, 2025 at 3:54 PM Shakir Idrisi <sha...@webuzo.com> wrote: >>> >>>> HI, >>>> >>>> I have used this command, and I have created a systemd file to start >>>> and stop the service. >>>> >>>> *ExecStart=/var/w-data/pgadmin4/pgadmin_venv/bin/gunicorn \* >>>> * --workers 1 \* >>>> * --threads=25 \* >>>> * --bind unix:/tmp/pgadmin4.sock \* >>>> * --chdir >>>> /var/w-data/pgadmin4/pgadmin_venv/lib/python3.11/site-packages/pgadmin4 \* >>>> * --umask 007 \* >>>> * pgAdmin4:app* >>>> >>>> Also, when I try multiple times then it will log in and show a blank >>>> dashboard, or sometimes it will show a dashboard but not work properly. In >>>> the console log, I see the following error >>>> >>>> [image: image.png] >>>> >>>> On Tue, Jun 10, 2025 at 3:26 PM Yogesh Mahajan < >>>> yogesh.maha...@enterprisedb.com> wrote: >>>> >>>>> Hi, >>>>> >>>>> Can you please share your guicorn command? >>>>> How many workers are you spawning? It should be 1. >>>>> >>>>> Thanks, >>>>> Yogesh Mahajan >>>>> EnterpriseDB >>>>> >>>>> >>>>> On Tue, Jun 10, 2025 at 12:34 PM Shakir Idrisi <sha...@webuzo.com> >>>>> wrote: >>>>> >>>>>> Hi, >>>>>> >>>>>> I've installed *pgAdmin 4* on my Linux server and configured it >>>>>> behind *Gunicorn and NGINX*, accessible at: >>>>>> https://domain.com/pgadmin4/. >>>>>> >>>>>> The login page loads correctly. However, after entering valid >>>>>> credentials, I'm redirected back to the login page without any error >>>>>> message. Occasionally, I see a *CSRF token* error, which disappears >>>>>> after a page refresh, but the login still fails. >>>>>> >>>>>> In the browser console or network tab, I sometimes see 401 errors or >>>>>> issues loading static assets. >>>>>> >>>>>> Here's the NGINX configuration I'm currently using to reverse proxy >>>>>> pgAdmin via a Unix socket: >>>>>> >>>>>> *nginx* >>>>>> location /pgadmin4/ { >>>>>> proxy_pass http://unix:/tmp/pgadmin4.sock:/; >>>>>> >>>>>> # Proxy headers >>>>>> proxy_set_header Host $host; >>>>>> proxy_set_header X-Real-IP $remote_addr; >>>>>> proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; >>>>>> proxy_set_header X-Forwarded-Proto $scheme; >>>>>> >>>>>> # Inform pgAdmin it's served under a subpath >>>>>> proxy_set_header X-Script-Name /pgadmin4; >>>>>> >>>>>> # Optional: timeouts and static asset handling >>>>>> proxy_read_timeout 300; >>>>>> proxy_connect_timeout 60; >>>>>> } >>>>>> >>>>>> Could you please advise: >>>>>> >>>>>> 1. >>>>>> >>>>>> Is there something wrong with the proxy setup? >>>>>> 2. >>>>>> >>>>>> Do I need to handle static assets or cookies differently when >>>>>> using a subpath (/pgadmin4)? >>>>>> 3. >>>>>> >>>>>> Are there any additional settings required in the pgAdmin config >>>>>> to work correctly behind a sub-URI with NGINX? >>>>>> >>>>>> Thanks in advance for your guidance. >>>>>> >>>>>
