Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
2
Newest
 Student
Impact
~129 people reached

  • 0 posts edited
  • 0 helpful flags
  • 4 votes cast
Feb
6
comment Rely on .pgpass in CREATE USER MAPPING
That won't fly for me because of security issues... at least for the moment. However, contains a good idea and have upvoted. Thanks!
Jan
28
comment Rely on .pgpass in CREATE USER MAPPING
Your reasoning sounds good... hmm... fdw is acting as a client to the server -- it could have an option to look in a .pgpass local to the server, for which security would be more easily maintained than if I have to put in my script. Not saying it does, of course. Still would be nice to see where the options are documented, although "except for user and password" would make it seem that these are the only ones for "create user mapping". ... thanks!
Jan
28
awarded  Student
Jan
28
asked Rely on .pgpass in CREATE USER MAPPING
Apr
26
awarded  Supporter