On 9/11/20 7:25 AM, Anthony Somerset wrote:
> Good Day
>
> Firstly I apologise if this has been formally requested before or if
> there is a better place for this to go..
https://www.pgadmin.org/support/issues/https://azure.microsoft.com/en-us/support/create-ticket/
>
> While trying to debug why the docker image would not deploy and run on
> Azure Kubernetes Service (AKS) I finally got to the bottom of it in that
> AzureFile and possible also AzureDisk storage backends have issues with
> SQLITE and locking
> (https://github.com/kubernetes/kubernetes/issues/59755) – while I was
> able to workaround the issue with the nobrl mount option mentioned on
> the linked issue it does raise concerns about potential data corruption
> of the SQLite DB in event of any issues. At least as it concerns to AKS
> there isn’t any real immediate improvement to be had.
>
> It got me thinking, it would be really great if pgadmin could support
> alternative storage backends for this data, my first prize would
> obviously be towards supporting postgres as a backend.
>
> While I appreciate there aren’t particularly any performance concerns
> with sqlite as its used in pgadmin4 it but it does potentially cause
> challenges when/if you need to scale the deployment and how you manage
> things at that point. It really would make life easier from a management
> perspective once you need to start scaling to multiple instances of
> pgadmin or want to create DR scenarios and replicatio of the data if
> other backends were available.
>
> Anthony Somerset
--
Adrian Klaver
adrian.klaver@aklaver.com
