Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links

From: aditya desai <admad123(at)gmail(dot)com>
To: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links
Date: 2021-12-17 15:43:32
Message-ID: CAN0SRDEGsXnULFzB+X7FNzwO4iT27G=rDhe9GgvMnhsj98KKPw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

Regards,
Aditya.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jonathan Katz 2021-12-17 16:11:55 Re: Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links
Previous Message hubert depesz lubaczewski 2021-12-15 11:36:44 Re: ERROR ON INSERTING USING A CURSOR IN EDB POSTGRESQL