We have developed a RESTful self service portal to provision PostgreSQL databases (using docker container) to different datacenter. New customer can self-register and start provisioning databases instantly. As part of the offering we plan next to provide pgAdmin in each datacenter in server mode. Several questions came up: 1.) How I can programmatically add new users to pgAdmin (.. and not enter them manually inside the web UI) ? The idea would be that inside our UI the user can request an pgAdmin account and our API would remotely execute inside the pgAdmin container (via docker exec) some command or operation that adds
the user id with its initial password. 2.) Is there any plan to add AD integration ? 3.) For availability reason we support different datacenter. In each dc a pgAdmin instance would be running. Is there any way to sync these pgAdmin instances? From what I have seen you are using sqlite as persistence backend.
Is it possible to persist the data to some alternative backend, e.g. a shared central PostgreSQL database? In this way the user config and settings that a user enters when he is connected to pgAdmin in dc A would be available when he connects to pgAdmin in dc B,C, etc.. Alternatively is it possible to copy over the pgAdmin sqlite database from dc A to the other dcs every night and restart pgAdmin in the other dcs in order to sync all configs to all other sites
(assuming that dc A would be used as “master” site)? Thanks for your feedback and this great tool
Cheers Heiko Geschäftsanschrift/Business address: METRO-nom GmbH, Metro-Straße 12,
40235 Duesseldorf, Germany Betreffend Mails von *@metronom.com
Regarding mails from *@metronom.com |
- pgAdmin in a multi DC self service context heiko.onnebrink
- Re: pgAdmin in a multi DC self service context Dave Page
- Re: pgAdmin in a multi DC self service context heiko.onnebrink