Re: tcpip dumps of txn

Ted Rolle wrote:
> How may I reproduce the TCP/IP dump on page 7(pdf); 6(doc) of 'Postgresql
> Internals through Pictures'?
>
> I'm using Ethereal on a Windows XP box.
>
> TCP/IP Packet
> 17:05:22.715714 family.home.49165 > candle.navpoint.com.5432: P 354:400(46)
> ack 61 win 8760 <nop,nop,timestamp 137847 7276138> (DF)
> 0000: 00 d0 b7 b9 b6 c8 00 02 b3 04 09 dd 08 00 45 00 ________ ______E_
> 0010: 00 62 45 31 40 00 40 06 b1 fe ac 14 00 02 a2 21 _bE1(at)_@_ _______!
> 0020: f5 2e c0 0d 15 38 1c af 94 34 a8 1a 1e 39 80 18 _.___8__ _4___9__
> 0030: 22 38 19 d5 00 00 01 01 08 0a 00 02 1a 77 00 6f "8______ _____w_o
> 0040: 06 6a 51 53 45 4c 45 43 54 20 66 69 72 73 74 6e _jQSELEC T firstn
> 0050: 61 6d 65 0a 46 52 4f 4d 20 66 72 69 65 6e 64 0a ame_FROM friend_
> 0060: 57 48 45 52 45 20 61 67 65 20 3d 20 33 33 3b 00 WHERE ag e = 33;_
> PostgreSQL Internals 6

Uh, on BSD, I just used tcpdump -X.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073