Data transfer format between UNIX server and Windows client?

From: "Paul A(dot) Lender" <lender(at)tc(dot)umn(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Cc: Paul A Lender <lender(at)tc(dot)umn(dot)edu>
Subject: Data transfer format between UNIX server and Windows client?
Date: 2001-04-05 14:25:28
Message-ID: 4.2.2.20010405091930.00aafeb0@lender.email.umn.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)tc(dot)umn(dot)edu

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurent MARTIN 2001-04-05 14:31:57 Arrays and COPY FROM: Help!!!
Previous Message Tom Lane 2001-04-05 14:23:03 Re: Almost all access to database hangs (fwd)