Thread: unknown error

unknown error

From
Dirk Drechsel
Date:
Hi, <p>I had to install pgsql 6.3.2. because of compatibility reasons. <br />The compiling part finishes without any
problemsand the html-access to the <br />database works, too. <br />The problem is - I cannot start the frontend psql
andhave following <br />error messages: <br />         Connection to database 'postgres' failed. <br />        
Unsupportedfrontend protocol. <p>I've never come across any of these messages before. Does anyone know what <br />they
mean?I have tried to compile pgsql with other templates, but no <br />success...:( <p>I'd be grateful for any help...
<p>Regards<br /><a href="mailto:drechsel@glamus.de">Dirk Drechsel</a><br /><a
href="mailto:webmaster@glamus.de">WebMaster</a><br/><a href="http://www.glamus.de/">Glamus GmbH</a><br />  

Re: [SQL] unknown error

From
Herouth Maoz
Date:
At 12:10 +0200 on 20/10/1999, Dirk Drechsel wrote:


> I had to install pgsql 6.3.2. because of compatibility reasons.
> The compiling part finishes without any problems and the html-access to the
> database works, too.
> The problem is - I cannot start the frontend psql and have following
> error messages:
>          Connection to database 'postgres' failed.
>          Unsupported frontend protocol.
>
> I've never come across any of these messages before.

The protocol that frontend applications (relying on libraries) use has
changed some time around 6.4. The message probably means that the frontend
applications are linked with the newer libraries, and your old 6.3.2
database can't understand them.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma




Re: [SQL] unknown error

From
Tom Lane
Date:
Herouth Maoz <herouth@oumail.openu.ac.il> writes:
>> The problem is - I cannot start the frontend psql and have following
>> error messages:
>>  Connection to database 'postgres' failed.
>>  Unsupported frontend protocol.

> The protocol that frontend applications (relying on libraries) use has
> changed some time around 6.4. The message probably means that the frontend
> applications are linked with the newer libraries, and your old 6.3.2
> database can't understand them.

Yes, exactly.  You'll need to use a 6.3.2 psql (or at least a 6.3.2
libpq) to talk to your old server.  The newer servers still talk to
old clients, but not vice versa...
        regards, tom lane


Re: [SQL] unknown error

From
Dirk Drechsel
Date:
Thank you very much!
Now it works! :-)


Herouth Maoz wrote:

> At 12:10 +0200 on 20/10/1999, Dirk Drechsel wrote:
>
> > I had to install pgsql 6.3.2. because of compatibility reasons.
> > The compiling part finishes without any problems and the html-access to the
> > database works, too.
> > The problem is - I cannot start the frontend psql and have following
> > error messages:
> >          Connection to database 'postgres' failed.
> >          Unsupported frontend protocol.
> >
> > I've never come across any of these messages before.
>
> The protocol that frontend applications (relying on libraries) use has
> changed some time around 6.4. The message probably means that the frontend
> applications are linked with the newer libraries, and your old 6.3.2
> database can't understand them.
>
> Herouth
>
> --
> Herouth Maoz, Internet developer.
> Open University of Israel - Telem project
> http://telem.openu.ac.il/~herutma
>
> ************