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?
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 |