Hi,
last couple of requests/help if possible:
1. if I paste from clipboard to PSQL TOOL I get the message "To paste data on the PSQL terminal, Clipboard read permission required.". I cannot find a related option in the configuration, may be it's not possible to date.
2. install PSPG into the container to be able to use it for pagination. Can I do it myself?
pgstage13:5432 postgres@rete_llpp=# select * from metadata.stations;
sh: pspg: not found
Thanks,
Paolo
Hi
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?
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
"Don't Complain about Heat, Plant a TREE"
--