Hi On Fri, May 4, 2018 at 4:28 AM, Peter Palka <ppa...@cmcrc.com> wrote:
> Hi Dave, > > According to SQLite load: just speculation. > > According to not supporting Postgres user data storage in Postgres client: > well, in this case the container looks more like nice flavour rather than > reliable solution. Every time I will kill the docker container or there > will be failure the user data will be lost. It will be good to at least > mount SQLite user database as an external volume (and mention it in docker > hub). > There are two examples on the docker hub page, and the second describes exactly that: ==== Run a TLS secured container using a shared config/storage directory in /private/var/lib/pgadmin on the host: docker pull dpage/pgadmin4 docker run -p 443:443 \ -v "/private/var/lib/pgadmin:/var/lib/pgadmin" \ -v "/path/to/certificate.cert:/certs/server.cert" \ -v "/path/to/certificate.key:/certs/server.key" \ -e "PGADMIN_DEFAULT_EMAIL=u...@domain.com" \ -e "PGADMIN_DEFAULT_PASSWORD=SuperSecret" \ -e "PGADMIN_ENABLE_TLS=True" \ -d dpage/pgadmin4 ==== They important line is the first -v option which maps the config directory to the host under docker (you could of course do something similar with a PVC under Kubernetes/OpenShift, but I don't have a recipe for that). To make it production ready it should be able to handle connection to > external database. > I always chuckle when I hear things like that; "to make it production ready you need feature X", though I grant you it's usually for much more trivial (and often questionable) features than you're requesting. That said; whilst it's been suggested that we use an external DB instead of SQLite and it's certainly possible, I can recall just a couple of requests for it since our first release, neither of which had any concrete need for it beyond essentially "we think this will be a good idea", which means it's almost certainly going to be a low priority tasks compared to many of the other things on the todo list. Please do add a feature request to the tracker though (https://redmine.postgresql.org/projects/pgadmin4/issues/new) for future consideration. If you want to work on it yourself, we'll certainly support that. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
