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(dot)Elphick(at)lfix(dot)co(dot)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