Search Postgresql Archives

Re: unsupported frontend protocol

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


  

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux