Postgres Pro
Downloads
Home   >   mailing lists

SSL mode detection - Mailing list pgsql-general

From Bosco Rama
Subject SSL mode detection
Date
Msg-id 4F302685.3000202@boscorama.com
Whole thread Raw
List pgsql-general
Tree view 
Hi folks,

I'm using PG 8.4.10 on Ubuntu Server 10.04.3.LTS x86_64.

Is there any way to query the SSL mode for client connections?

E.g.  select backend_id from some_table_or_view where ssl_mode = false;

I have not been able to find it in pg_stat_activity or anywhere else in
the catalog.  Maybe I'm just blind. :-(

TIA.

Bosco.

pgsql-general by date:

Previous
From: Misa Simic
Date:
Subject: Re: How to create crosstab with 3 values in every crosstab column
Next
From: "Marc Mamin"
Date:
Subject: Re: How to create crosstab with 3 values in every crosstab column