Re: Connect as multiple users using single client certificate

2019-10-11 Thread Kyle Bateman
On 10/11/19 1:05 PM, Tom Lane wrote: Kyle Bateman writes: On 10/11/19 12:12 PM, Andrew Dunstan wrote: I think the short answer is: No. The client certificate should match the username and nothing else. If you don't want to generate certificates for all your users I suggest using some

Re: Connect as multiple users using single client certificate

2019-10-11 Thread Kyle Bateman
On 10/11/19 12:12 PM, Andrew Dunstan wrote: On 10/11/19 1:58 PM, Kyle Bateman wrote: I have some JS middleware that needs to securely connect to the postgresql back end.  Any number of different users may connect via websocket to this middleware to manage their connection to the database.  I

Connect as multiple users using single client certificate

2019-10-11 Thread Kyle Bateman
I have some JS middleware that needs to securely connect to the postgresql back end.  Any number of different users may connect via websocket to this middleware to manage their connection to the database.  I want the JS process to have a client certificate authorizing it to connect to the datab