Re: [GENERAL] Unsupported frontend protocol error?

Alvaro Castillo wrote:

  >When I try to use postgres 6.4 I get this error:
  >
  >Connection to database 'mydb' failed.
  >Unsupported frontend protocol.

The error comes from the postmaster:
 /* Check we can handle the protocol the frontend is using. */

        if (PG_PROTOCOL_MAJOR(port->proto) < PG_PROTOCOL_MAJOR(PG_PROTOCOL_EARLIEST) ||
                PG_PROTOCOL_MAJOR(port->proto) > PG_PROTOCOL_MAJOR(PG_PROTOCOL_LATEST) ||
                (PG_PROTOCOL_MAJOR(port->proto) == PG_PROTOCOL_MAJOR(PG_PROTOCOL_LATEST) &&
                 PG_PROTOCOL_MINOR(port->proto) > PG_PROTOCOL_MINOR(PG_PROTOCOL_LATEST)))
        {
                PacketSendError(&port->pktInfo, "Unsupported frontend protocol.");
                return STATUS_OK;               /* don't close the connection yet */
        }

Since 6.4 can cope with earlier protocols (
libpq/pqcomm.h:#define PG_PROTOCOL_EARLIEST     PG_PROTOCOL(0,0)
libpq/pqcomm.h:#define PG_PROTOCOL_LATEST       PG_PROTOCOL(2,0)
)
it seems likely that you are using an earlier postmaster with a later pgsql.


--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
               PGP key from public servers; key ID 32B8FAA1
                 ========================================
     "But I say unto you, That every idle word that men
      shall speak, they shall give account thereof in the
      day of judgment."           Matthew 12:36