Subject: Re: two factor authentication for pgadmin iii
To: pgsql-general@postgresql.org
References: 
 <CAGVXacayiAmZcBYqe5WMhf05cW-ToDvOAtF89=-oNk5w_Xm_Rg@mail.gmail.com>
From: John R Pierce <pierce@hogranch.com>
Message-ID: <55DF4235.3070506@hogranch.com>
Date: Thu, 27 Aug 2015 10:00:37 -0700
User-Agent: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:38.0) Gecko/20100101
 Thunderbird/38.2.0
MIME-Version: 1.0
In-Reply-To: 
 <CAGVXacayiAmZcBYqe5WMhf05cW-ToDvOAtF89=-oNk5w_Xm_Rg@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org

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


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general