agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: redlich@dame.informatik.uni-dortmund.de
To: J.Plewe <joerg.plewe@mpi-dortmund.mpg.de>
Cc: postgres@postgres.Berkeley.EDU
Subject: Re: version 4.2 ..?
Date: Mon, 11 Jul 94 11:43:23 N
Message-ID: <9407110943.AA07388@dame.informatik.uni-dortmund.de> (raw)
In-Reply-To: <9407010920.AA16297@dl.mpi-dortmund.mpg.de>


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.
==============================================================================

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: redlich@dame.informatik.uni-dortmund.de, joerg.plewe@mpi-dortmund.mpg.de
  Subject: Re: version 4.2 ..?
  In-Reply-To: <9407110943.AA07388@dame.informatik.uni-dortmund.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox