Thread: help needed!!!
<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><brclear="all" /><hr /><a href="http://g.msn.com/8HMBENUS/2746??PS=">AddMSN 8 Internet Software to your existing Internet access and enjoy patentedspam protection and more. Sign up now! </a>
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
Softwareto 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
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
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 >
scott.marlowe writes: > 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. This is not correct. Old client libraries can connect to new servers. In any case, the error message in case of a version mismatch is not "invalid length of startup packet", so this whole discussion is not the solution to the original question. -- Peter Eisentraut peter_e@gmx.net