| From: | Jonathan Katz <jonathan(dot)katz(at)excoventures(dot)com> |
|---|---|
| To: | aditya desai <admad123(at)gmail(dot)com> |
| Cc: | pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links |
| Date: | 2021-12-17 16:11:55 |
| Message-ID: | A0E82030-D418-4596-A6E5-87016B0CCCE7@excoventures.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
> On Dec 17, 2021, at 10:43 AM, aditya desai <admad123(at)gmail(dot)com> wrote:
>
> Hi,
> Is there any way to achieve autonomous transactions in Postgres? There is a way to do it by using DB Link. However DB Link involves user name and password which is a bit of a security threat.
>
> How to use certificate based authentication in DB Links instead of hardcoding user name and password in it?
dblink lets you pass in a PostgreSQL connection string[1].
From there you can reference parameters to use certificates[2].
Jonathan
[1] https://www.postgresql.org/docs/current/contrib-dblink-connect.html <https://www.postgresql.org/docs/current/contrib-dblink-connect.html>
[2] https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-PARAMKEYWORDS
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2021-12-17 16:27:30 | Re: Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links |
| Previous Message | aditya desai | 2021-12-17 15:43:32 | Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links |