Re: Container deploy & PSQL tool - Mailing list pgadmin-support

From Dave Page
Subject Re: Container deploy & PSQL tool
Date
Msg-id CA+OCxow-+7gAx2_rQ0DeWW2HL=qXZGhHesC7bxr7t9V1pOT7fw@mail.gmail.com
Whole thread Raw
In response to Re: Container deploy & PSQL tool  (Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>)
Responses Re: Container deploy & PSQL tool
Re: Container deploy & PSQL tool
List pgadmin-support
Hi

On Wed, Aug 18, 2021 at 5:33 AM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:
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@domain.com' \

    -e 'PGADMIN_DEFAULT_PASSWORD=SuperSecret' \

    -d dpage/pgadmin4


That will certainly work (as Paolo has confirmed) for a single user, however, I think we should set PSQLRC and PSQL_HISTORY in the environment for psql when running in server mode such that those files go into each individual user's storage directory.

Can you raise an RM for that and take a look at it please Aditya?
 

On Mon, Aug 16, 2021 at 10:58 AM Paolo Saudin <paolosaudin@gmail.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
"Don't Complain about Heat, Plant a TREE"


--

pgadmin-support by date:

Previous
From: Paolo Saudin
Date:
Subject: Re: Container deploy & PSQL tool
Next
From: Paolo Saudin
Date:
Subject: Re: Container deploy & PSQL tool