one client with multiple ssl cert connections to different databases

Поиск
Список
Период
Сортировка
От Megan
Тема one client with multiple ssl cert connections to different databases
Дата
Msg-id CACMA5-zx1EDA7tfkydbVeBTq88hFUcb4Jwq9aFYfw-Q6pMF-gQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: one client with multiple ssl cert connections to different databases  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-admin
Good Day All


I setup my postgres servers to allow certificate authentication.  Right now I have two database servers and one application server.  Users are only allowed to connect into the application server, invoke psql, then connect into which ever database server they want.  I have the keys and certs for db server 1 in their .postgresql folder under their home and it works fine, but i can't figure out how to properly setup the environment so that they can connect into either db server with the keys.  I tried to merge the key/cert files in their .postgresql directory with info for both db servers but that didn't work.  I feel like there is an obvious solution to this that I can't see.  Any ideas?

В списке pgsql-admin по дате отправления:

Предыдущее
От: David Johnston
Дата:
Сообщение: Re: How was I able to drop a role even though objects depend on it?
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: one client with multiple ssl cert connections to different databases