Hi, On Tue, Nov 5, 2024 at 11:07 PM Maurice Lajoie <moe...@runbox.com> wrote:
> Hi, > I successfully deployed pgAdmin web on our SAP BTP Cloud Foundry and can > access pgAdmin and logon. > I can create users and servers but when the app restarts, all entries are > lost. I’m assuming it’s using SQLite which would not be persistent in the > Cloud Foundry. > You can map the pgAdmin Data directory to the outside container, so it can persist the SQLite and other data. Ref: https://www.pgadmin.org/docs/pgadmin4/8.12/container_deployment.html > I did bind web-pgadmin to a PostgreSQL, Hyperscaler Option database. > > I added the user-provided variable to PGADMIN_CONFIG_CONFIG_DATABASE_URI > with: > postgres:// > xxxxxxxxxxxxx:ff855340a50467bb21eb...@postgres-xxxxxxxxx-f2a1-45c2-9e9d-4cef636bcf77.cmqeanecqlnd.ca-central-1.rds.amazonaws.com:1831/xxDB-Namexx Please refer to https://www.pgadmin.org/docs/pgadmin4/latest/external_database.html for the correct variable value. Thanks, Khushboo > > > I restarted the pgadmin-web app and it crashed. > > Please find attached the application start log. I changed some of the text > with “xxx” for security. > > For the deployment, I used a docker image: > applications: > - name: pgadmin-web > docker: > image: dpage/pgadmin4:2024-10-19-2 > instances: 1 > memory: 1G > disk_quota: 1G > health-check-type: process > env: > PGADMIN_DEFAULT_EMAIL: <email address> > PGADMIN_DEFAULT_PASSWORD: <new password> > PGADMIN_LISTEN_ADDRESS: 0.0.0.0 > > Thank you > Moelaj >
