Data transfer format between UNIX server and Windows client? - Mailing list pgsql-general

From Paul A. Lender
Subject Data transfer format between UNIX server and Windows client?
Date
Msg-id 4.2.2.20010405091930.00aafeb0@lender.email.umn.edu
Whole thread Raw
Responses Re: Data transfer format between UNIX server and Windows client?
Re: Data transfer format between UNIX server and Windows client?
Re: Data transfer format between UNIX server and Windows client?
List pgsql-general
Hi folks

I submitted this directly to the novice and general news groups -- getting
no responses -- before I had subscribed to the list, and I apologize to
anyone who may have responded previously.

I've got a FreeBSD 4.2 box running PostgreSQL 7.0.3 and Windows clients
that talk to it via LIBPQ.DLL (Zeos controls, ODBC, pgAccess...).

I have a firewall on the BSD box using ipf, but I have to assume -- at
least for the sake of argument -- that someone can still monitor data
coming off the box.

MY QUESTION -- When query results are sent to the client, where does the
conversion of stored binary data to easily readable text take
place:  on the server before it leaves for the clients, or at libpq.dll ON
the clients?

If the transfer between boxes is text, does anyone have experience using an
encrypted connection between a Unix box and a Windows client (without using
a web server, that is)?

Thanks in advance...

-- Paul Lender
========================================
Paul A. Lender
University of Minnesota Department of Orthopaedic Surgery
420 Delaware St. S.E., MMC 492 Mayo
Minneapolis  MN  55455
Voice: (612) 625-1186
FAX: (612) 626-6032
e-mail: lender@tc.umn.edu


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Almost all access to database hangs (fwd)
Next
From: Tom Lane
Date:
Subject: Re: cant delete row