Re: Container deploy & PSQL tool

Hi Dave,

On Wed, Aug 18, 2021 at 12:25 PM Dave Page <dpage(at)pgadmin(dot)org> wrote:

> Hi
>
> On Wed, Aug 18, 2021 at 5:33 AM Aditya Toshniwal <
> aditya(dot)toshniwal(at)enterprisedb(dot)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(at)domain(dot)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?
>
Got it. I'll create the RM.

>
>
>>
>> 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"
>>
>
>
> --
> Dave Page
> Blog: https://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EDB: https://www.enterprisedb.com
>
>

--
Thanks,
Aditya Toshniwal
pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com*
<http://edbpostgres.com>
"Don't Complain about Heat, Plant a TREE"