Sure, basically, modern versions of the client library can talk to older
versions of the database backend up to a point (i.e. the 7.4 library in
beta can go back to 6.5 or 6.4 or something like that. Support for 6.2 or
thereabouts was recently dropped.)
However, going the other way, old connect libs and newer postgresql back
end versions can result in an issue where the old lib can't connect.
the normal solution is to link to / use the newer connection libraries
that come with a late model pgsql (7.3, 7.4 etc...)
On Tue, 23 Sep 2003, Priya G wrote:
>
> Since I am a novice can you explain more about this version mismatch?
>
> >From: Bruce Momjian <pgman@candle.pha.pa.us>
> >To: Priya G <sreepriya@hotmail.com>
> >CC: pgsql-admin@postgresql.org
> >Subject: Re: [ADMIN] help needed!!!
> >Date: Mon, 22 Sep 2003 14:46:27 -0400 (EDT)
> >
> >Priya G wrote:
> >[ text/html is unsupported, treating like TEXT/PLAIN ]
> >
> > > <html><div style='background-color:'><DIV>
> > > <DIV>Hi all,</DIV>
> > > <DIV> </DIV>
> > > <DIV> The following message was found in the postgres
> >log</DIV>postgres[20563]: [73256]
> >
> >
> > FATAL 1: invalid length of startup packet
> >
> >
> > > <DIV> what does this mean?</DIV>
> > > <DIV> </DIV>
> > > <DIV>Thanks</DIV></DIV></div><br clear=all><hr> <a
> >href="http://g.msn.com/8HMBENUS/2746??PS=">Add MSN 8 Internet Software to
> >your existing Internet access and enjoy patented spam protection and more.
> >Sign up now! </a> </html>
> >
> >Odds are you have a mismatch between the client version and the server
> >version.
> >
> >--
> > Bruce Momjian | http://candle.pha.pa.us
> > pgman@candle.pha.pa.us | (610) 359-1001
> > + If your life is a hard drive, | 13 Roberts Road
> > + Christ can be your backup. | Newtown Square, Pennsylvania
> >19073
>
> _________________________________________________________________
> Instant message with integrated webcam using MSN Messenger 6.0. Try it now
> FREE! http://msnmessenger-download.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>