Re: Container deploy & PSQL tool

From: Paolo Saudin <paolosaudin(at)gmail(dot)com>
To: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
Cc: "pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Re: Container deploy & PSQL tool
Date: 2021-08-18 05:13:29
Message-ID: CADtZQgm0npDPOrV5ZjXG8fbR+AhSdzzpm0yzj-jNqBEX-jd-6g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Thank you very much, I managed to map the directory and now all is fine!
Paolo

docker run -p 5050:80 \
-v pga4volume:/var/lib/pgadmin \
-v pga4volume:/home/pgadmin \
-e 'PGADMIN_DEFAULT_EMAIL=user(at)domain(dot)com' *\*
-e 'PGADMIN_DEFAULT_PASSWORD=SuperSecret' *\*
-e 'PGADMIN_CONFIG_ENABLE_PSQL=True \
-d dpage/pgadmin4

-> sudo ls -lart /var/lib/docker/volumes/pga4volume/_data/
drwxr-xr-x 3 5050 5050 4096 Jan 24 2019 ..
drwxr-xr-x 7 5050 5050 4096 Jun 22 2020 storage
drwx------ 3 5050 5050 16384 Aug 18 04:49 sessions
-rw------- 1 5050 5050 26 Aug 18 05:06 .psql_history
-rw------- 1 5050 5050 40964096 Aug 18 05:06 pgadmin4.db
-rw-r--r-- 1 5050 5050 7514 Aug 18 05:07 .psqlrc
drwx------ 4 5050 5050 4096 Aug 18 05:07 .

Il giorno mer 18 ago 2021 alle ore 06:33 Aditya Toshniwal <
aditya(dot)toshniwal(at)enterprisedb(dot)com> ha scritto:

> Hi Paolo,
>
> I did something like this to mount my host home directory to docker
> /home/pgadmin. .psqlrc defaults to user home directory which is
> /home/pgadmin. Can you try this once ?
>
> docker run -p 80:80 *\*
>
> -v /Users/adityatoshniwal:/home/pgadmin \
>
> -e 'PGADMIN_DEFAULT_EMAIL=user(at)domain(dot)com' *\*
>
> -e 'PGADMIN_DEFAULT_PASSWORD=SuperSecret' *\*
>
> -d dpage/pgadmin4
>
> On Mon, Aug 16, 2021 at 10:58 AM Paolo Saudin <paolosaudin(at)gmail(dot)com>
> wrote:
>
>> Hi,
>> I installed pgAdmin4 with the directory "/var/lib/pgadmin" mapped
>> locally. I then set the PGADMIN_CONFIG_ENABLE_PSQL to True to be able to
>> use the PSQL TOOL.
>>
>> Now when I exit the console with "\q" I get the following error: 'could
>> not save history to file "/home/pgadmin/.psql_history": No such file or
>> directory'. Is it possible to map this directory as well?
>>
>> Last question, where can I create a .psqlrc file?
>>
>> Than you,
>> Paolo Saudin
>>
>>
>>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com*
> <http://edbpostgres.com>
> "Don't Complain about Heat, Plant a TREE"
>

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2021-08-18 06:54:58 Re: Container deploy & PSQL tool
Previous Message Khushboo Vashi 2021-08-18 04:39:12 Re: pgAdmin4 stopped working with VPN upon upgrade.