Re: pgAdmin in Docker: independent users storage - Mailing list pgadmin-support

From Dave Page
Subject Re: pgAdmin in Docker: independent users storage
Date
Msg-id CA+OCxozprVOjJ7ODrpPsPOi+upTjaxWvboGVKnp4-H4weRw0FA@mail.gmail.com
Whole thread Raw
In response to Re: pgAdmin in Docker: independent users storage  (Vladimir Ryabtsev <greatvovan@gmail.com>)
Responses Re: pgAdmin in Docker: independent users storage  (Vladimir Ryabtsev <greatvovan@gmail.com>)
List pgadmin-support


On Sat, Sep 15, 2018 at 6:33 AM, Vladimir Ryabtsev <greatvovan@gmail.com> wrote:
I am using dpage/pgadmin4, which is referenced from https://www.pgadmin.org/download/pgadmin-4-container/
Does it have similar env. var.?

When you launch with docker you'd use something like the following on the command line to map the directory containing session data and configs to the host:

-v "/private/var/lib/pgadmin:/var/lib/pgadmin"

The first path being the one on the host, the second being the path in the container to remap.

I don't know how that's done in Rancher.
 
Will try your image anyway.

Regards,
Vlad

пт, 24 авг. 2018 г. в 1:17, Henrik Uggla <Henrik.Uggla@kristianstad.se>:
Yes, put the Sqlite file (by default named pgadmin4.db) on a shared persistent volume on f ex Rancher-NFS. I don't know which Docker image you are using but if you use mine (huggla/pgadmin-alpine), then you're able to change the location of the sqlite file inside the container by setting the environment variable VAR_param_SQLITE_PATH.

Cheers,
Henrik
________________________________________
Från: Vladimir Ryabtsev <greatvovan@gmail.com>
Skickat: den 24 augusti 2018 01:25:37
Till: pgadmin-support@lists.postgresql.org
Ämne: pgAdmin in Docker: independent users storage

Hi,

I am running pgAdmin in Rancher, which means the container, in some circumstances, can be moved to another host. In this case I lose all users as well as users' settings (set-up server connections), which in turn implies I have to re-create users and they have to set up everything again.

To make pgAdmin tolerant to restarts and moves, I guess I need to put it's database on some volume that would be mounted to container on any host.

How to do it?

Best regards,
Vladimir



--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgadmin-support by date:

Previous
From: Khushboo Vashi
Date:
Subject: Re: Help
Next
From: Henrik Uggla
Date:
Subject: Re: pgAdmin in Docker: independent users storage