Re: Backend Protocol

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: dave(at)fastcrypt(dot)com
Cc: "'Barry Lind'" <barry(at)xythos(dot)com>, "'PostgreSQL-development'" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Backend Protocol
Date: 2001-11-03 18:02:12
Message-ID: 2507.1004810532@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers pgsql-jdbc

"Dave Cramer" <dave(at)fastcrypt(dot)com> writes:
> This will involve understanding the client/backend protocol completely.
> So far I have found one reference to this. Does anyone have a flow chart
> or can point me to any other references.

The only documentation I know of is the protocol chapter in the PG
Developer's Guide:
http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/protocol.html

The development-sources version of this has additional entries for the
new authentication methods added in 7.2. It's still missing any
discussion of SSL encryption :-(

It would probably be useful to add something flowchart-ish to section
4.2.2 to show the typical sequence of messages for various commands.
However, I'd caution you against wiring in more assumptions than you
absolutely must about message order. It's best to build the client
library as a state machine that will accept any message type at any
time that the message makes any sense.

regards, tom lane

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message tgl 2001-11-03 21:42:47 pgsql/doc/src/sgml array.sgml catalogs.sgml re ...
Previous Message Dave Cramer 2001-11-03 16:22:31 Backend Protocol

Browse pgsql-hackers by date

  From Date Subject
Next Message Domingo Alvarez Duarte 2001-11-03 18:16:55 Re: Porting Web application written in Oracle 8 PL/SQL to Postgresql
Previous Message Tom Lane 2001-11-03 17:53:03 Re: Fw: LISTENING THE PORT

Browse pgsql-jdbc by date

  From Date Subject
Next Message Peter Eisentraut 2001-11-04 13:05:24 Re: [COMMITTERS] pgsql/ oc/src/sgml/client-auth.sgml
Previous Message Dave Cramer 2001-11-03 16:22:31 Backend Protocol