Обсуждение: public key authentification

Hi folks,


is there a way to do pubkey authentification (like ssh) with
postgresql and the psql frontend ?


thx.
--
---------------------------------------------------------------------
 Enrico Weigelt    ==   metux IT service

  phone:     +49 36207 519931         www:       http://www.metux.de/
  fax:       +49 36207 519932         email:     contact@metux.de
  cellphone: +49 174 7066481
---------------------------------------------------------------------
 -- DSL ab 0 Euro. -- statische IP -- UUCP -- Hosting -- Webshops --
---------------------------------------------------------------------

> is there a way to do pubkey authentification (like ssh) with
> postgresql and the psql frontend ?

Not really.

You can use SSH forwarding of the connection, and use the public key
authentication for that one.

Or you can use Kerberos 5 - while not public key authentication, it may
accomplish what you wanted.

You can also request that the client has a client certificate on a SSL
connection, but you cannot map client certificates to user account so
anybody who has a valid client cert by your CA can connect then.

//Magnus