User account and settings storage in other database than SQLite

From: Peter Palka <ppalka(at)cmcrc(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: User account and settings storage in other database than SQLite
Date: 2018-05-03 03:50:02
Message-ID: CALW5h1W6YfS-bRY2v9tZ6cH5eFauSmM4A7gUQhaJnuK1XqBKdA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,

I'd like to deploy pgAdmin in cloud container environment and use
PostgreSQL database as users' data storage. The reasons are:

- we have +30 users that are heavily using pgAdmin
- our PostgreSQL cloud database has higher stability level than our
cloud container infrastructure
- it will be much easier to scale pgAdmin in the future if we will use
container-independent database

SQLite is not designed to handle heavy traffic and we don't want to keep
users data in the filesystem as in case of failure all data will be lost.
I'm also afraid that sooner or later it will become a performance
bottleneck.

I've checked web/config.py and web/setup.py
(commit 59d8f6fb84e0aabc098fecf968cde3f9fcdf53b0 Wed May 2 16:51:17 2018
+0100) and I was unable to find any way to initialise pgAdmin with
Postgresql as a user data storage backend.

Documentation also says nothing about database other than SQLite
(Development version (GIT head Thu May 3 13:45 2018 +1000).

Is there any way to set up pgAdmin with other database than SQLite?
(Postgresql preferable)

Regards,
Peter

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Khushboo Vashi 2018-05-03 05:37:42 Re: pgAdmin4 - V3 - Problems managing passwords
Previous Message Douglas Reed 2018-05-02 08:37:52 pgAdmin4 - V3 - Problems managing passwords