Re: Strange error (Socket command option unknown)

From: Carlos Moreno <moreno(at)mochima(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Strange error (Socket command option unknown)
Date: 2003-02-24 22:31:10
Message-ID: 3E5A9D2E.4070808@mochima.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:

>
>You should look very hard at the part of your code that deals with
>error reports from the server.
>
>It might be worth logging the whole session between client and
>server with tcpdump --- that'd be tedious to wade through, but
>it might give some evidence of what's happening. It seems pretty
>clear that the client is sending an incomplete message, but knowing
>only one character of the broken message isn't much to help you
>debug it. With a tcpdump trace you could see the whole packet ...
>

Ok, it would look like I am going to have to face the
terror of doing this! :-)

However, I have zero experience on this; if I may,
I'd like to ask for some pointers on this tcpdump;

checking the man pages, I came up with:

tcpdump -i local port 5432

I then connected using psql -h localhost, as a test;
it seems to be showing only timing and length information.
What could I do?

The other thing is that this is only a quick test to first
see that I can figure out the information that tcpdump
gives me... But the connection is not being done through
TCP/IP, since the application and postmaster are running
on the same physical machine.

So, how can I listen on local (i.e., AF_UNIX) sockets?
(which I assume is the way my application and the postgres
server communicate)

Thanks!

Carlos
--

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2003-02-24 23:24:59 Re: I cant find it or I'm just lazy ?
Previous Message Dmitry Tkach 2003-02-24 21:14:45 Re: how do i avoid multiple sessions from inserting the