1. David Puche
  2. Valentina Studio
  3. Monday, September 28 2020, 07:57 PM
  4.  Subscribe via email
Hello,

Do you think it would be possible to add support to specify the pgfile to use for connecting to a postgresql server ? In the connection dialog or by specifying the PGPASSFILE environment variable maybe. It would allow to setup multiple SSH tunneled connections to 127.0.0.1:5432 with pgpass support.

Thanks.
Comment
There are no comments made yet.
David Puche Accepted Answer
Thanks, it works.
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello David,

A standard libpq library is used so PGPASSFILE environment variable or placing it at a default place should work.

When SSH is used, libpq connects to the local socket at 127.0.0.1 but the port is assigned dynamically.
References
  1. https://www.postgresql.org/docs/12/libpq-pgpass.html
Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories