How can I be confirm that data is encrypted over the network using SSL

From: AI Rumman <rummandba(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: How can I be confirm that data is encrypted over the network using SSL
Date: 2010-05-05 05:01:29
Message-ID: i2n2a7905441005042201j7180b760s2e47710fed4f2666@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2010-05-05 05:12:14 Re: How can I be confirm that data is encrypted over the network using SSL
Previous Message Bryan Murphy 2010-05-05 02:53:47 Postgres 9.0 Hot Standby + Fail Over