Re: two factor authentication for pgadmin iii

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: two factor authentication for pgadmin iii
Date: 2015-08-27 17:00:37
Message-ID: 55DF4235.3070506@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

On 8/26/2015 11:55 PM, Nima Azizzadeh wrote:
> Hello,
> I'm going to create two factor authentication for pgadmin server...

you mean postgresql server, don't you? pgadmin is a client program/utility.

> I'm using postgresql 9.4 with pgadmin III on Linux Mint 17.2 32bit...
> I already have 1 password authentication but For better security, I
> just want to force 2 of them. The authentication factors could be any
> things(what people have,what people know,where people are or what
> people are).
> Could anybody help me on this?
>

one standard way of doing 2-factor is to use ssl keys, with a password
on the ssl key store.

But, how will that work with application programs connecting to
postgres, such as a webserver based application ?

--
john r pierce, recycling bits in santa cruz

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ryan King - NOAA Affiliate 2015-08-27 17:46:26 $libdir/mysql_fdw
Previous Message Nima Azizzadeh 2015-08-27 06:56:08 Fwd: two factor authentication for pgadmin iii

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-08-27 17:29:20 Re: ERROR: collation "latin1_general_ci" for encoding "UTF8" does not exist
Previous Message David Nelson 2015-08-27 16:35:56 Re: UPDATE an updatable view