pgadmin-org
hope to store session in PostgreSQL database
Describe the solution you'd like
Dear Developer,
I use multiple nodes to run pgadmin4 in server mode, PostgreSQL as database, 'SESSION_DB_PATH' is defined in local path file. When user's request sends to other node, the request session missing causing relogin. So I hope to store session in PostgreSQL database instead of in local path file. In this situation multiple nodes will share session.
Thanks for your reply.
Hi @ghr111, do multiple nodes mean different pgAdmin installations OR multiple users with the same pgAdmin server?
Hi @ghr111, do multiple nodes mean different pgAdmin installations OR multiple users with the same pgAdmin server? @khushboovashi , Thanks for your reply, It's the former different pgAdmin installations on some machines and ngix is in the front.
Session storage is only part of the problem - the more important consideration is that the database connections cannot be shared between the nodes. It's unlikely there is any sane way to solve that problem.
@dpage Thanks for your reply, I use external databases PostgreSQL which store pgAdmin4 configuration settings, the settings in the databases can be shared between the nodes. But the session and uploaded files (refer to issue #7651 https://github.com/pgadmin-org/pgadmin4/issues/7651) is stored in server local machine, so I want to store data in PostgreSQL database.
pgAadmin4 version: 6.21
