--- Darcy Buskermolen <darcy at wavefire.com> wrote:

> 
> Does psql using ssl from/to the db's in question
> work properly?  Because slon 
> and slonik are just libpq apps and this error looks
> to be coming from within 
> libpq (pqcomm.c) 
> 

I ran the following on system A, connecting to system
B.  It seemed to work just fine (the query ran over
and over and over).  It ran for several minutes with
no crashes.  


djenkins at A$ while [ "1" == "1" ] ; do  psql -Uslony
-hB B-DATABASE -c "select count(*), table_name from
audit group by table_name order by 1 desc limit 10;" ;
done


I know that is it using an SSL connection.  Host B
won't allow non-SSL at the moment & when I connect
interactively is says "SSL connection (cipher:
DHE-RSA-AES256-SHA, bits: 256)".  I could not think of
any other easy way to use libpq to test the
connection.

I could try to craft something in perl.  Sometimes I
use DBD::Pg (uses libpq) and other times DBD::PgPP
(implements pgsql protocol in perl, so no libpq). 
Would this help with the diagnosis?


Dennis Jenkins