From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Anthony Somerset <Anthony(dot)Somerset(at)liquidtelecom(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Feature Request pgadmin4 support more storage backends for servers/user data |
Date: | 2020-09-11 17:20:10 |
Message-ID: | 7be54b07-1e75-5ebd-f513-55a13f0d21ba@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Brian Dunavant | 2020-09-11 17:43:01 | Re: Inserting many rows using "with" |
Previous Message | Harmen | 2020-09-11 15:33:20 | Inserting many rows using "with" |