Issue migrated from Redmine: https://redmine.postgresql.org/issues/3336
Originally created by Peter Palka at 2018-05-07 02:32:11 UTC.

h1. Current user settings storage
Right now all user settings are stored in SQLite database file in /var/lib/pgadmin/pgadmin4.db.

h1. Proposal
Ability to store user settings on external database like PostgreSQL

h1. Motivation
During large pgAdmin4 deployment (for example on AWS using Auto Scaling group with load balancer) we can't rely on single SQLite file database as it:

Is not prepared to be failure-proof (no HA support),

May be a bottleneck (not designed to handle many connections concurrently reading/writing data to it).

This implies it can be single point of failure.

To prevent it we can separate user data storage from pgAdmin4 web service by using external database for user storage on another machine. To achieve it the external database connector will be needed.