Re: Container deploy & PSQL tool

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"

--

Dave Page
Blog: https://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: https://www.enterprisedb.com