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.
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.
David Puche Accepted Answer
Thanks, it works.
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