How can I be confirm that data is encrypted over the network using SSL - Mailing list pgsql-general

From AI Rumman
Subject How can I be confirm that data is encrypted over the network using SSL
Date
Msg-id i2n2a7905441005042201j7180b760s2e47710fed4f2666@mail.gmail.com
Whole thread Raw
Responses Re: How can I be confirm that data is encrypted over the network using SSL  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
I have configured SSL connection between client/server using self-signed certificate.

----------------------------------------------------------------------------------
Password:
Welcome to psql 8.3.8, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)

postgres=# \l
        List of databases
   Name    |  Owner   | Encoding
-----------+----------+----------
 postgres  | postgres | UTF8
 template0 | postgres | UTF8
 template1 | postgres | UTF8
(3 rows)
--------------------------------------------------------------------------------------

PGDATA dir:

-------------------------------------------------------------------

-bash-3.2$ ls -l
total 84
drwx------ 5 postgres postgres  4096 May  4 14:09 base
drwx------ 2 postgres postgres  4096 May  5 10:58 global
...
-rw------- 1 postgres postgres  3600 May  4 14:17 server.crt
-rw------- 1 postgres postgres   887 May  4 14:17 server.key
-rw------- 1 postgres postgres  2195 May  4 14:16 server.req

----------------------------------------------------------------------

Client ~/.postgresql dir

--------------------------------------------

-bash-3.2$ ls -l
total 12
-rw-r--r-- 1 postgres postgres 3259 May  4 18:36 postgresql.crt
-rw------- 1 postgres postgres  887 May  4 18:35 postgresql.key
-rw-r--r-- 1 postgres postgres 2080 May  4 18:35 postgresql.req

--------------------------------------------


I set the $PGSSLMODE=require to encrypt data across the netwrok.


How could I be sure that data is encrypted over the network?


pgsql-general by date:

Previous
From: Bryan Murphy
Date:
Subject: Postgres 9.0 Hot Standby + Fail Over
Next
From: John R Pierce
Date:
Subject: Re: How can I be confirm that data is encrypted over the network using SSL