Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199407110943.CAA19102@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
From: redlich@dame.informatik.uni-dortmund.de
Message-Id: <9407110943.AA07388@dame.informatik.uni-dortmund.de>
To: joerg.plewe@mpi-dortmund.mpg.de (J.Plewe)
Cc: postgres@postgres.Berkeley.EDU
Subject: Re: version 4.2 ..? 
In-Reply-To: Your message of Fri, 01 Jul 94 11:20:15 +0200.
             <9407010920.AA16297@dl.mpi-dortmund.mpg.de> 
Date: Mon, 11 Jul 94 11:43:23 N
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Mon, 11 Jul 94 02:43:40 -0700
Resent-XMts: smtp


Hello Joerg,

> > 
> > Does any body have a stable version 4.2 running on sun 4.1.3 ??
> > 
> > I have installed 4.2-beta version , but it didn't even pass its
> > own regression tests .. quite a few times I got the error flags
> > from the backend & PQexec .. 
> > 
> > The following is the error I got while doing :
> > 
> > >  System:  sun os 4.1.3  / postgres 4.2.beta
> > >
> > > * retrieve (ntable.all) \g
> > >
> > > Query sent to backend is "retrieve (ntable.all) "
> > > FATAL: no response from backend: detected in PQexec
> > 
> 
> I have it running, but not completely stable at all. I very often
> get messages like
> 
>   FATAL 1:Jul  1 07:57:17:database template1 does not exist, bailing out...
> 
> with any database name (e.g. regression, plewe, ...)
> 
> I'm of course sure thta the databases actually exist. I get the 
> message from one query to the next.
> 

We had the same problem , although we were working with local
databases. (The possibility Paul Aoki mentioned)
One reason was the use of a tcsh.The shell changed at the
runtime the PGDATA-value.(incredible, but true)
We coped with the problem by using the normal csh. Until now is the
system running.
We had seen the mistake by running postmaster with the debug-option.
I hope this will help you. 

> Restarting the postmaster removes the error.
> 
> At home I build postgres for Linux from the same sources with the patches
> from Kai Petzke and I don't see this error!
> 
> - Joerg
> 
> *********************************************************************
> Dipl. Phys. Joerg Plewe               joerg.plewe@mpi-dortmund.mpg.de
> MPI fuer molekulare Physiologie


-         Marcus 

==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"

   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================