We've set up our postgres to use two factor authentication of normal users (password+otp via pam). But this makes pgAdmin pretty much unusable because it caches the password once connected and reuses the cached password for every additional connection to the same server.
I am able to connect to the the server, but I'm not able to select a different database (not a major issue), but I'm also not able to open the SQL window. Is there a way to disable this password caching and prompt every time a new connection is opened to the server? -- "If you dig a hole and itβs in the wrong place digging it deeper is not going to help." β Seymour Chwast β Michiel Hendriks, MSc MP Objects - Supply Chain Systems β michiel.hendr...@mp-objects.com π www.mp-objects.com β +31 102900304
