Re: unsupported frontend protocol

[Bucks vs Bytes Inc <postgresql@xxxxxxxxxxxxxxxx>]

Connection logging shows an unvarying pattern: every connection attempt, regardless of target database or source (PHP or psql), first uses a wrong protocol and then succeeds on a second attempt, presumably after falling back:

LOG:  connection received: host=[local]
FATAL:  unsupported frontend protocol
LOG:  connection received: host=[local]
LOG:  connection authorized: user=testuser database=test

Any thoughts on what could make both clients attempt wrong protocol?

/usr/lib has the following libpq files:
-rw-r--r--    1 root     root       592784 Jun 24  2004 /usr/lib/libpq.a
lrwxrwxrwx    1 root     root           12 Jul  8  2004 /usr/lib/libpq.so -> libpq.so.3.1
lrwxrwxrwx    1 root     root           12 Nov 28  2003 /usr/lib/libpq.so.2 -> libpq.so.2.2
-rwxr-xr-x    1 root     root        61252 Nov  4  2003 /usr/lib/libpq.so.2.2
lrwxrwxrwx    1 root     root           12 Jul  8  2004 /usr/lib/libpq.so.3 -> libpq.so.3.1
-rwxr-xr-x    1 root     root       112040 Jun 24  2004 /usr/lib/libpq.so.3.1


Tom Lane wrote:

Bucks vs Bytes Inc <postgresql@xxxxxxxxxxxxxxxx> writes:
  

Is there any postmaster logging I can turn on that will detail what's 
triggering the error?
    

Well, you could change the error report in postmaster.c to show the
specific protocol version code it's receiving (7.4 and up do this,
but it hadn't occurred to us as of 7.3).  I have little doubt what
you will find though.  Maybe what you really want is to enable
log_connections so you can find out where the problematic connections
are coming from.

			regards, tom lane